| Subject | Re: [firebird-support] FB 1.5 RC6 linear slowdown |
|---|---|
| Author | Rajesh Punjabi |
| Post date | 2003-09-30T09:25:06Z |
Hi Martin,
Thanks for your prompt reply. Heres the GSTAT output. I am not sure what
you mean by transaction counters. Like I said in my posting, I do not
know how to interpret Gstat. If you or some one else could point me to
the information I will read up on it.
I forgot to mention that we are using SuperSever FB.
Thanks again.
Rajesh
Database "d:\Firebird\TG.FDB"
Database header page information:
Flags 0
Checksum 12345
Generation 14501
Page size 8192
ODS version 10.1
Oldest transaction 14490
Oldest active 14491
Oldest snapshot 14491
Next transaction 14492
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 9000
Next header page 0
Database dialect 3
Creation date Sep 30, 2003 12:20:05
Attributes no reserve
Variable header data:
Sweep interval: 20000
*END*
Database file sequence:
File d:\Firebird\TG.FDB is the only file
Database log page information:
Creation date
Log flags: 2
No write ahead log
Next log page: 0
Variable log data:
Control Point 1:
File name:
Partition offset: 0 Seqno: 0 Offset: 0
Control Point 2:
File name:
Partition offset: 0 Seqno: 0 Offset: 0
Current File:
File name:
Partition offset: 0 Seqno: 0 Offset: 0
*END*
Analyzing database pages ...
ACCESSLISTSUBSCRIBERNETWORK_5 (175)
Primary pointer page: 236, Index root page: 237
Data pages: 1, data page slots: 1, average fill: 2%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ACCESSLIST_5 (174)
Primary pointer page: 234, Index root page: 235
Data pages: 1, data page slots: 1, average fill: 1%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ALARM (149)
Primary pointer page: 184, Index root page: 185
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
AP_ROLES (164)
Primary pointer page: 214, Index root page: 215
Data pages: 1, data page slots: 1, average fill: 2%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
AP_SCHEDULES (150)
Primary pointer page: 186, Index root page: 187
Data pages: 1, data page slots: 1, average fill: 2%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
AP_SCHEDULES_LOG (152)
Primary pointer page: 190, Index root page: 191
Data pages: 1, data page slots: 1, average fill: 37%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
AP_USER (162)
Primary pointer page: 210, Index root page: 211
Data pages: 1, data page slots: 1, average fill: 2%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
AP_USERROLES (167)
Primary pointer page: 220, Index root page: 221
Data pages: 1, data page slots: 1, average fill: 1%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
AP_XML_CONFIG (147)
Primary pointer page: 180, Index root page: 181
Data pages: 1, data page slots: 1, average fill: 73%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0
BILLING (198)
Primary pointer page: 282, Index root page: 283
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
BILLINGRECORDS (197)
Primary pointer page: 280, Index root page: 281
Data pages: 8, data page slots: 8, average fill: 85%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 7
BUILD_INFO (145)
Primary pointer page: 176, Index root page: 177
Data pages: 1, data page slots: 1, average fill: 0%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
CHASSIS_5 (176)
Primary pointer page: 238, Index root page: 239
Data pages: 1, data page slots: 1, average fill: 1%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
CONFIG_SKELETON_5 (185)
Primary pointer page: 256, Index root page: 257
Data pages: 1, data page slots: 1, average fill: 7%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
CRYPTOMAP_5 (177)
Primary pointer page: 240, Index root page: 241
Data pages: 1, data page slots: 1, average fill: 1%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
CSPNETWORK_5 (178)
Primary pointer page: 242, Index root page: 243
Data pages: 1, data page slots: 1, average fill: 0%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DESTINATION (141)
Primary pointer page: 168, Index root page: 169
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DUAL (172)
Primary pointer page: 230, Index root page: 231
Data pages: 1, data page slots: 1, average fill: 0%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ENACTELEMIMPL (151)
Primary pointer page: 188, Index root page: 189
Data pages: 2, data page slots: 2, average fill: 72%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 1
ENACTSEQWIIMPL (153)
Primary pointer page: 192, Index root page: 193
Data pages: 7, data page slots: 7, average fill: 95%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 6
EXTERNAL_SYSTEM (131)
Primary pointer page: 148, Index root page: 149
Data pages: 1, data page slots: 1, average fill: 6%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
HANDLEIMPL (155)
Primary pointer page: 196, Index root page: 197
Data pages: 234, data page slots: 234, average fill: 98%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 233
HIST_RECORD_ACTIVITY (129)
Primary pointer page: 144, Index root page: 145
Data pages: 117, data page slots: 117, average fill: 98%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 116
HIST_RECORD_ORDER (128)
Primary pointer page: 142, Index root page: 143
Data pages: 42, data page slots: 42, average fill: 98%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 41
HIST_SERVICEPACK (130)
Primary pointer page: 146, Index root page: 147
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
IKEPOLICY_5 (179)
Primary pointer page: 244, Index root page: 245
Data pages: 1, data page slots: 1, average fill: 1%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
INOTIFICATION (157)
Primary pointer page: 200, Index root page: 201
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
INTERFACE_5 (180)
Primary pointer page: 246, Index root page: 247
Data pages: 1, data page slots: 1, average fill: 20%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
JMS_MESSAGES (170)
Primary pointer page: 226, Index root page: 227
Data pages: 1, data page slots: 13, average fill: 5%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
JMS_TRANSACTIONS (171)
Primary pointer page: 228, Index root page: 229
Data pages: 1, data page slots: 1, average fill: 1%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MANUALTASK_INSTANCE (158)
Primary pointer page: 202, Index root page: 203
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MODULE_DEPENDENCIES (139)
Primary pointer page: 164, Index root page: 165
Data pages: 1, data page slots: 1, average fill: 1%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MODULE_DESTINATION (142)
Primary pointer page: 170, Index root page: 171
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MODULE_EXT_SYS (133)
Primary pointer page: 152, Index root page: 153
Data pages: 1, data page slots: 1, average fill: 0%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MODULE_TABLE (132)
Primary pointer page: 150, Index root page: 151
Data pages: 1, data page slots: 1, average fill: 3%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MODULE_XML_DATA (140)
Primary pointer page: 166, Index root page: 167
Data pages: 5, data page slots: 5, average fill: 84%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 4
NETWORKELEMENTTYPE_5 (182)
Primary pointer page: 250, Index root page: 251
Data pages: 1, data page slots: 1, average fill: 1%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
NETWORKELEMENT_5 (181)
Primary pointer page: 248, Index root page: 249
Data pages: 1, data page slots: 1, average fill: 2%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
OBJECT_STORE (148)
Primary pointer page: 182, Index root page: 183
Data pages: 358, data page slots: 358, average fill: 97%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 357
ORDER_DETAILS (135)
Primary pointer page: 156, Index root page: 157
Data pages: 7, data page slots: 7, average fill: 59%
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 2
60 - 79% = 0
80 - 99% = 3
PE_5 (184)
Primary pointer page: 254, Index root page: 255
Data pages: 1, data page slots: 1, average fill: 2%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PORTTYPE_5 (187)
Primary pointer page: 260, Index root page: 261
Data pages: 1, data page slots: 1, average fill: 1%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PORT_5 (183)
Primary pointer page: 252, Index root page: 253
Data pages: 1, data page slots: 1, average fill: 2%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PROCESSIMPL (159)
Primary pointer page: 204, Index root page: 205
Data pages: 1, data page slots: 1, average fill: 7%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PROCESSOR (134)
Primary pointer page: 154, Index root page: 155
Data pages: 1, data page slots: 1, average fill: 68%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0
PROCESS_INSTANCE (136)
Primary pointer page: 158, Index root page: 159
Data pages: 1, data page slots: 11, average fill: 13%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PROCESS_INSTANCE_EXT_SYS_LINK (137)
Primary pointer page: 160, Index root page: 161
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PROPAWAREENTIMPL (160)
Primary pointer page: 206, Index root page: 207
Data pages: 1, data page slots: 1, average fill: 7%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PROPERTYIMPL (161)
Primary pointer page: 208, Index root page: 209
Data pages: 1000, data page slots: 1000, average fill: 98%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 999
PROTOCOLCONFIGURE_5 (189)
Primary pointer page: 264, Index root page: 265
Data pages: 1, data page slots: 1, average fill: 1%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PROTOCOLTYPE_5 (190)
Primary pointer page: 266, Index root page: 267
Data pages: 1, data page slots: 1, average fill: 1%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PROTOCOL_5 (188)
Primary pointer page: 262, Index root page: 263
Data pages: 1, data page slots: 1, average fill: 1%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
RACK_5 (191)
Primary pointer page: 268, Index root page: 269
Data pages: 1, data page slots: 1, average fill: 1%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ROOTENACTCTXIMPL (163)
Primary pointer page: 212, Index root page: 213
Data pages: 1, data page slots: 1, average fill: 7%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SCHED_ORDER (156)
Primary pointer page: 198, Index root page: 199
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SEQUENCE (165)
Primary pointer page: 216, Index root page: 217
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SERVICE_PROVIDER_5 (186)
Primary pointer page: 258, Index root page: 259
Data pages: 1, data page slots: 1, average fill: 0%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SLOTCARD_5 (192)
Primary pointer page: 270, Index root page: 271
Data pages: 1, data page slots: 1, average fill: 1%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SUBRECIMPL (166)
Primary pointer page: 218, Index root page: 219
Data pages: 354, data page slots: 354, average fill: 98%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 353
SUBSCRIBERNETWORK_5 (194)
Primary pointer page: 274, Index root page: 275
Data pages: 1, data page slots: 1, average fill: 4%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SUBSCRIBER_5 (193)
Primary pointer page: 272, Index root page: 273
Data pages: 1, data page slots: 1, average fill: 0%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SYSLOG_CHANNEL (144)
Primary pointer page: 174, Index root page: 175
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SYSLOG_LEVEL (143)
Primary pointer page: 172, Index root page: 173
Data pages: 1, data page slots: 1, average fill: 3%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SYSLOG_LOG (146)
Primary pointer page: 178, Index root page: 179
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TRANSFORMSET_5 (196)
Primary pointer page: 278, Index root page: 279
Data pages: 1, data page slots: 1, average fill: 0%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TRANSFORM_5 (195)
Primary pointer page: 276, Index root page: 277
Data pages: 1, data page slots: 1, average fill: 2%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TRANSITIONIMPL (168)
Primary pointer page: 222, Index root page: 223
Data pages: 2, data page slots: 2, average fill: 71%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 1
WFINSTANCE_ORDER (154)
Primary pointer page: 194, Index root page: 195
Data pages: 6, data page slots: 6, average fill: 86%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 5
WORKITEMIMPL (169)
Primary pointer page: 224, Index root page: 225
Data pages: 332, data page slots: 332, average fill: 98%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 331
WORKLISTIMPL (173)
Primary pointer page: 232, Index root page: 233
Data pages: 1, data page slots: 1, average fill: 3%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XML_DATA (138)
Primary pointer page: 162, Index root page: 163
Data pages: 132, data page slots: 132, average fill: 93%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 12
80 - 99% = 119
Martijn Tonies wrote:
Thanks for your prompt reply. Heres the GSTAT output. I am not sure what
you mean by transaction counters. Like I said in my posting, I do not
know how to interpret Gstat. If you or some one else could point me to
the information I will read up on it.
I forgot to mention that we are using SuperSever FB.
Thanks again.
Rajesh
Database "d:\Firebird\TG.FDB"
Database header page information:
Flags 0
Checksum 12345
Generation 14501
Page size 8192
ODS version 10.1
Oldest transaction 14490
Oldest active 14491
Oldest snapshot 14491
Next transaction 14492
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 9000
Next header page 0
Database dialect 3
Creation date Sep 30, 2003 12:20:05
Attributes no reserve
Variable header data:
Sweep interval: 20000
*END*
Database file sequence:
File d:\Firebird\TG.FDB is the only file
Database log page information:
Creation date
Log flags: 2
No write ahead log
Next log page: 0
Variable log data:
Control Point 1:
File name:
Partition offset: 0 Seqno: 0 Offset: 0
Control Point 2:
File name:
Partition offset: 0 Seqno: 0 Offset: 0
Current File:
File name:
Partition offset: 0 Seqno: 0 Offset: 0
*END*
Analyzing database pages ...
ACCESSLISTSUBSCRIBERNETWORK_5 (175)
Primary pointer page: 236, Index root page: 237
Data pages: 1, data page slots: 1, average fill: 2%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ACCESSLIST_5 (174)
Primary pointer page: 234, Index root page: 235
Data pages: 1, data page slots: 1, average fill: 1%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ALARM (149)
Primary pointer page: 184, Index root page: 185
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
AP_ROLES (164)
Primary pointer page: 214, Index root page: 215
Data pages: 1, data page slots: 1, average fill: 2%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
AP_SCHEDULES (150)
Primary pointer page: 186, Index root page: 187
Data pages: 1, data page slots: 1, average fill: 2%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
AP_SCHEDULES_LOG (152)
Primary pointer page: 190, Index root page: 191
Data pages: 1, data page slots: 1, average fill: 37%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
AP_USER (162)
Primary pointer page: 210, Index root page: 211
Data pages: 1, data page slots: 1, average fill: 2%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
AP_USERROLES (167)
Primary pointer page: 220, Index root page: 221
Data pages: 1, data page slots: 1, average fill: 1%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
AP_XML_CONFIG (147)
Primary pointer page: 180, Index root page: 181
Data pages: 1, data page slots: 1, average fill: 73%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0
BILLING (198)
Primary pointer page: 282, Index root page: 283
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
BILLINGRECORDS (197)
Primary pointer page: 280, Index root page: 281
Data pages: 8, data page slots: 8, average fill: 85%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 7
BUILD_INFO (145)
Primary pointer page: 176, Index root page: 177
Data pages: 1, data page slots: 1, average fill: 0%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
CHASSIS_5 (176)
Primary pointer page: 238, Index root page: 239
Data pages: 1, data page slots: 1, average fill: 1%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
CONFIG_SKELETON_5 (185)
Primary pointer page: 256, Index root page: 257
Data pages: 1, data page slots: 1, average fill: 7%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
CRYPTOMAP_5 (177)
Primary pointer page: 240, Index root page: 241
Data pages: 1, data page slots: 1, average fill: 1%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
CSPNETWORK_5 (178)
Primary pointer page: 242, Index root page: 243
Data pages: 1, data page slots: 1, average fill: 0%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DESTINATION (141)
Primary pointer page: 168, Index root page: 169
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DUAL (172)
Primary pointer page: 230, Index root page: 231
Data pages: 1, data page slots: 1, average fill: 0%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ENACTELEMIMPL (151)
Primary pointer page: 188, Index root page: 189
Data pages: 2, data page slots: 2, average fill: 72%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 1
ENACTSEQWIIMPL (153)
Primary pointer page: 192, Index root page: 193
Data pages: 7, data page slots: 7, average fill: 95%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 6
EXTERNAL_SYSTEM (131)
Primary pointer page: 148, Index root page: 149
Data pages: 1, data page slots: 1, average fill: 6%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
HANDLEIMPL (155)
Primary pointer page: 196, Index root page: 197
Data pages: 234, data page slots: 234, average fill: 98%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 233
HIST_RECORD_ACTIVITY (129)
Primary pointer page: 144, Index root page: 145
Data pages: 117, data page slots: 117, average fill: 98%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 116
HIST_RECORD_ORDER (128)
Primary pointer page: 142, Index root page: 143
Data pages: 42, data page slots: 42, average fill: 98%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 41
HIST_SERVICEPACK (130)
Primary pointer page: 146, Index root page: 147
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
IKEPOLICY_5 (179)
Primary pointer page: 244, Index root page: 245
Data pages: 1, data page slots: 1, average fill: 1%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
INOTIFICATION (157)
Primary pointer page: 200, Index root page: 201
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
INTERFACE_5 (180)
Primary pointer page: 246, Index root page: 247
Data pages: 1, data page slots: 1, average fill: 20%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
JMS_MESSAGES (170)
Primary pointer page: 226, Index root page: 227
Data pages: 1, data page slots: 13, average fill: 5%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
JMS_TRANSACTIONS (171)
Primary pointer page: 228, Index root page: 229
Data pages: 1, data page slots: 1, average fill: 1%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MANUALTASK_INSTANCE (158)
Primary pointer page: 202, Index root page: 203
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MODULE_DEPENDENCIES (139)
Primary pointer page: 164, Index root page: 165
Data pages: 1, data page slots: 1, average fill: 1%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MODULE_DESTINATION (142)
Primary pointer page: 170, Index root page: 171
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MODULE_EXT_SYS (133)
Primary pointer page: 152, Index root page: 153
Data pages: 1, data page slots: 1, average fill: 0%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MODULE_TABLE (132)
Primary pointer page: 150, Index root page: 151
Data pages: 1, data page slots: 1, average fill: 3%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MODULE_XML_DATA (140)
Primary pointer page: 166, Index root page: 167
Data pages: 5, data page slots: 5, average fill: 84%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 4
NETWORKELEMENTTYPE_5 (182)
Primary pointer page: 250, Index root page: 251
Data pages: 1, data page slots: 1, average fill: 1%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
NETWORKELEMENT_5 (181)
Primary pointer page: 248, Index root page: 249
Data pages: 1, data page slots: 1, average fill: 2%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
OBJECT_STORE (148)
Primary pointer page: 182, Index root page: 183
Data pages: 358, data page slots: 358, average fill: 97%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 357
ORDER_DETAILS (135)
Primary pointer page: 156, Index root page: 157
Data pages: 7, data page slots: 7, average fill: 59%
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 2
60 - 79% = 0
80 - 99% = 3
PE_5 (184)
Primary pointer page: 254, Index root page: 255
Data pages: 1, data page slots: 1, average fill: 2%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PORTTYPE_5 (187)
Primary pointer page: 260, Index root page: 261
Data pages: 1, data page slots: 1, average fill: 1%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PORT_5 (183)
Primary pointer page: 252, Index root page: 253
Data pages: 1, data page slots: 1, average fill: 2%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PROCESSIMPL (159)
Primary pointer page: 204, Index root page: 205
Data pages: 1, data page slots: 1, average fill: 7%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PROCESSOR (134)
Primary pointer page: 154, Index root page: 155
Data pages: 1, data page slots: 1, average fill: 68%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0
PROCESS_INSTANCE (136)
Primary pointer page: 158, Index root page: 159
Data pages: 1, data page slots: 11, average fill: 13%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PROCESS_INSTANCE_EXT_SYS_LINK (137)
Primary pointer page: 160, Index root page: 161
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PROPAWAREENTIMPL (160)
Primary pointer page: 206, Index root page: 207
Data pages: 1, data page slots: 1, average fill: 7%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PROPERTYIMPL (161)
Primary pointer page: 208, Index root page: 209
Data pages: 1000, data page slots: 1000, average fill: 98%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 999
PROTOCOLCONFIGURE_5 (189)
Primary pointer page: 264, Index root page: 265
Data pages: 1, data page slots: 1, average fill: 1%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PROTOCOLTYPE_5 (190)
Primary pointer page: 266, Index root page: 267
Data pages: 1, data page slots: 1, average fill: 1%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PROTOCOL_5 (188)
Primary pointer page: 262, Index root page: 263
Data pages: 1, data page slots: 1, average fill: 1%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
RACK_5 (191)
Primary pointer page: 268, Index root page: 269
Data pages: 1, data page slots: 1, average fill: 1%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ROOTENACTCTXIMPL (163)
Primary pointer page: 212, Index root page: 213
Data pages: 1, data page slots: 1, average fill: 7%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SCHED_ORDER (156)
Primary pointer page: 198, Index root page: 199
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SEQUENCE (165)
Primary pointer page: 216, Index root page: 217
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SERVICE_PROVIDER_5 (186)
Primary pointer page: 258, Index root page: 259
Data pages: 1, data page slots: 1, average fill: 0%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SLOTCARD_5 (192)
Primary pointer page: 270, Index root page: 271
Data pages: 1, data page slots: 1, average fill: 1%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SUBRECIMPL (166)
Primary pointer page: 218, Index root page: 219
Data pages: 354, data page slots: 354, average fill: 98%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 353
SUBSCRIBERNETWORK_5 (194)
Primary pointer page: 274, Index root page: 275
Data pages: 1, data page slots: 1, average fill: 4%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SUBSCRIBER_5 (193)
Primary pointer page: 272, Index root page: 273
Data pages: 1, data page slots: 1, average fill: 0%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SYSLOG_CHANNEL (144)
Primary pointer page: 174, Index root page: 175
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SYSLOG_LEVEL (143)
Primary pointer page: 172, Index root page: 173
Data pages: 1, data page slots: 1, average fill: 3%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SYSLOG_LOG (146)
Primary pointer page: 178, Index root page: 179
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TRANSFORMSET_5 (196)
Primary pointer page: 278, Index root page: 279
Data pages: 1, data page slots: 1, average fill: 0%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TRANSFORM_5 (195)
Primary pointer page: 276, Index root page: 277
Data pages: 1, data page slots: 1, average fill: 2%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TRANSITIONIMPL (168)
Primary pointer page: 222, Index root page: 223
Data pages: 2, data page slots: 2, average fill: 71%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 1
WFINSTANCE_ORDER (154)
Primary pointer page: 194, Index root page: 195
Data pages: 6, data page slots: 6, average fill: 86%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 5
WORKITEMIMPL (169)
Primary pointer page: 224, Index root page: 225
Data pages: 332, data page slots: 332, average fill: 98%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 331
WORKLISTIMPL (173)
Primary pointer page: 232, Index root page: 233
Data pages: 1, data page slots: 1, average fill: 3%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XML_DATA (138)
Primary pointer page: 162, Index root page: 163
Data pages: 132, data page slots: 132, average fill: 93%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 12
80 - 99% = 119
Martijn Tonies wrote:
>Hi Rajesh,
>
>
>
>>Our environment is WinXP, 2.4 GHZ P4, 512 MB RAM with FB 1.5 RC6. Our
>>application runs on JBoss 3.2.1 with JDK 1.3.1 and Jaybird 1.0. We have
>>stress tested our application with Oracle 8i and MySQL 4 with InnoDB
>>databases. We are now trying to port our application to Firebird.
>>
>>
>
>If you use "gstat" on your database, can you post the transaction
>counters?
>
>
>With regards,
>
>Martijn Tonies
>Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
>Upscene Productions
>http://www.upscene.com
>
>
>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>
>