[firebase-br] Ajuda em analise do banco
Antonio Carlos
a.lima.silva em terra.com.br
Ter Nov 18 17:20:07 -03 2008
Pessoal estou com um banco que após gfix, backup e gfix. Entrou em operação
as 12h de 18/11.
Fiz pelo IBO estatistioca do banco e apresentou as seguintes informações :
E em algumas tabelas outros dados que não soube interpretar, não sei se os
indices estão balanceados ou não.
Uma ajuda por favor.
Service started at 18/11/2008 15:46:29
Database "c:\data\gerente.frb"
Database header page information:
Flags 0
Checksum 12345
Generation 1110
Page size 8192
ODS version 10.1
Oldest transaction 113
Oldest active 746
Oldest snapshot 308
Next transaction 1104
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Nov 18, 2008 14:10:40
Attributes force write
Variable header data:
Sweep interval: 20000
*END*
Database file sequence:
File c:\data\gerente.frb 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 ...
CAB_NOTAENTREGA (174)
Primary pointer page: 279, Index root page: 280
Data pages: 3719, data page slots: 3719, average fill: 92%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 3718
Index IDX_CAB_NOTAENTREGA (1)
Depth: 2, leaf buckets: 255, nodes: 74452
Average data length: 21.00, total dup: 1, max dup: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 2
60 - 79% = 1
80 - 99% = 252
Index IDX_CAB_NOTAENTREGA1 (2)
Depth: 3, leaf buckets: 506, nodes: 74452
Average data length: 48.00, total dup: 24, max dup: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 3
60 - 79% = 0
80 - 99% = 503
Index RDB$PRIMARY99 (0)
Depth: 2, leaf buckets: 118, nodes: 74452
Average data length: 6.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 2
60 - 79% = 0
80 - 99% = 116
CAIXADIARIO (178)
Primary pointer page: 287, Index root page: 288
Data pages: 2214, data page slots: 2214, average fill: 89%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 2213
CLIENTE (159)
Primary pointer page: 248, Index root page: 249
Data pages: 607, data page slots: 607, average fill: 93%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 606
Index IDX_CLIENTE (0)
Depth: 2, leaf buckets: 71, nodes: 9529
Average data length: 53.00, total dup: 45, max dup: 13
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 71
Index IDX_CLIENTE1 (1)
Depth: 2, leaf buckets: 71, nodes: 9529
Average data length: 53.00, total dup: 45, max dup: 13
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 70
Index IDX_CLIENTE2 (2)
Depth: 2, leaf buckets: 11, nodes: 9529
Average data length: 2.00, total dup: 7097, max dup: 2842
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 10
Index IDX_CLIENTE3 (4)
Depth: 2, leaf buckets: 10, nodes: 9529
Average data length: 1.00, total dup: 4952, max dup: 3196
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 9
Index RDB$PRIMARY68 (3)
Depth: 2, leaf buckets: 23, nodes: 9529
Average data length: 13.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 22
COMISSAO (171)
Primary pointer page: 273, Index root page: 274
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
Index RDB$PRIMARY102 (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
CONTAS (173)
Primary pointer page: 277, Index root page: 278
Data pages: 2830, data page slots: 2830, average fill: 91%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 2829
Index IDX_CONTAS (3)
Depth: 3, leaf buckets: 290, nodes: 74651
Average data length: 25.00, total dup: 166, max dup: 7
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 4
60 - 79% = 0
80 - 99% = 286
Index IDX_CONTAS1 (0)
Depth: 2, leaf buckets: 118, nodes: 74638
Average data length: 6.00, total dup: 204, max dup: 7
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 2
60 - 79% = 0
80 - 99% = 115
Index IDX_CONTAS2 (1)
Depth: 2, leaf buckets: 90, nodes: 74638
Average data length: 3.00, total dup: 68932, max dup: 55397
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 2
60 - 79% = 0
80 - 99% = 87
Index IDX_CONTAS3 (4)
Depth: 2, leaf buckets: 56, nodes: 74638
Average data length: 0.00, total dup: 73815, max dup: 168
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 55
Index RDB$PRIMARY100 (2)
Depth: 2, leaf buckets: 109, nodes: 74638
Average data length: 5.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 3
60 - 79% = 0
80 - 99% = 106
CTL_IMPROM (186)
Primary pointer page: 303, Index root page: 304
Data pages: 1173, data page slots: 1173, average fill: 83%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 1172
Index IDX_CTL_IMPROM (1)
Depth: 2, leaf buckets: 50, nodes: 66136
Average data length: 0.00, total dup: 65276, max dup: 169
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 2
60 - 79% = 0
80 - 99% = 48
Index RDB$PRIMARY1 (0)
Depth: 2, leaf buckets: 170, nodes: 66136
Average data length: 14.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 3
60 - 79% = 0
80 - 99% = 167
ITENS_NTAENTREGA (184)
Primary pointer page: 299, Index root page: 300
Data pages: 4266, data page slots: 4266, average fill: 87%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 4265
Index RDB$PRIMARY103 (0)
Depth: 2, leaf buckets: 289, nodes: 170354
Average data length: 7.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 14
60 - 79% = 0
80 - 99% = 275
MOVIMENTACAO (183)
Primary pointer page: 297, Index root page: 298
Data pages: 4549, data page slots: 4549, average fill: 87%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 4548
Index RDB$PRIMARY94 (0)
Depth: 2, leaf buckets: 363, nodes: 193986
Average data length: 8.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 14
60 - 79% = 0
80 - 99% = 348
MOV_ENTRADA (161)
Primary pointer page: 252, Index root page: 253
Data pages: 349, data page slots: 349, average fill: 88%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 348
Index RDB$PRIMARY93 (0)
Depth: 2, leaf buckets: 22, nodes: 13460
Average data length: 5.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 5
60 - 79% = 0
80 - 99% = 17
MOV_SAIDA (163)
Primary pointer page: 256, Index root page: 257
Data pages: 7431, data page slots: 7431, average fill: 89%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 7430
Index IDX_MOV_SAIDA (1)
Depth: 3, leaf buckets: 649, nodes: 259096
Average data length: 14.00, total dup: 1, max dup: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 18
60 - 79% = 0
80 - 99% = 630
Index RDB$PRIMARY77 (0)
Depth: 3, leaf buckets: 451, nodes: 259096
Average data length: 8.00, total dup: 1, max dup: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 2
60 - 79% = 0
80 - 99% = 448
PEDIDO (160)
Primary pointer page: 250, Index root page: 251
Data pages: 5142, data page slots: 5142, average fill: 91%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 5141
Index IDX_PEDIDO (1)
Depth: 2, leaf buckets: 125, nodes: 127391
Average data length: 1.00, total dup: 50515, max dup: 50411
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 3
60 - 79% = 0
80 - 99% = 122
Index IDX_PEDIDO1 (2)
Depth: 2, leaf buckets: 144, nodes: 127412
Average data length: 2.00, total dup: 111838, max dup: 11882
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 22
60 - 79% = 0
80 - 99% = 121
Index RDB$PRIMARY70 (0)
Depth: 2, leaf buckets: 304, nodes: 127379
Average data length: 13.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 4
60 - 79% = 0
80 - 99% = 300
Service ended at 18/11/2008 15:46:38
Mais detalhes sobre a lista de discussão lista