[firebase-br] database statistic

Mauricio mauriciomoraes em 3protesto-sp.com.br
Ter Mar 14 10:42:17 -03 2006


bom dia a todos....



Quem poderia me auxiliar nesta estatística que o banco me retornou......



obrigado.

Database header page information: 

Flags 0 

Checksum 12345 

Generation 29 

Page size 4096 

ODS version 10.1 

Oldest transaction 6 

Oldest active 7 

Oldest snapshot 7 

Next transaction 23 

Bumped transaction 1 

Sequence number 0 

Next attachment ID 0 

Implementation ID 19 

Shadow count 0 

Page buffers 0 

Next header page 0 

Database dialect 3 

Creation date Mar 14, 2006 9:16:36 

Attributes 


Variable header data: 

Sweep interval: 20000 

*END* 



Database file sequence: 

File /home//Dados/Cart.gdb 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* 



GERAL (153) 

Primary pointer page: 447, Index root page: 448 

Data pages: 2964, data page slots: 2964, average fill: 89% 

Fill distribution: 

0 - 19% = 1 

20 - 39% = 0 

40 - 59% = 0 

60 - 79% = 0 

80 - 99% = 2963 


Index IDX_CODBAN (2) 

Depth: 2, leaf buckets: 28, nodes: 18559 

Average data length: 0.00, total dup: 18526, max dup: 4234 

Fill distribution: 

0 - 19% = 0 

20 - 39% = 0 

40 - 59% = 1 

60 - 79% = 0 

80 - 99% = 27 


Index IDX_Codbarracorreio (1) 

Depth: 2, leaf buckets: 46, nodes: 18559 

Average data length: 3.00, total dup: 1121, max dup: 926 

Fill distribution: 

0 - 19% = 0 

20 - 39% = 0 

40 - 59% = 1 

60 - 79% = 0 

80 - 99% = 45 


Index IDX_Docorrenc (3) 

Depth: 2, leaf buckets: 28, nodes: 18559 

Average data length: 0.00, total dup: 18541, max dup: 1405 

Fill distribution: 

0 - 19% = 0 

20 - 39% = 0 

40 - 59% = 1 

60 - 79% = 0 

80 - 99% = 27 


Index IDX_GERAL_1 (4) 

Depth: 2, leaf buckets: 28, nodes: 18559 

Average data length: 0.00, total dup: 18533, max dup: 3335 

Fill distribution: 

0 - 19% = 0 

20 - 39% = 0 

40 - 59% = 1 

60 - 79% = 0 

80 - 99% = 27 


Index IDX_GERAL_2 (5) 

Depth: 2, leaf buckets: 29, nodes: 18559 

Average data length: 0.00, total dup: 18034, max dup: 1151 

Fill distribution: 

0 - 19% = 0 

20 - 39% = 0 

40 - 59% = 1 

60 - 79% = 0 

80 - 99% = 28 


Index IDX_GERAL_3 (6) 

Depth: 2, leaf buckets: 30, nodes: 18559 

Average data length: 0.00, total dup: 17979, max dup: 1143 

Fill distribution: 

0 - 19% = 1 

20 - 39% = 0 

40 - 59% = 0 

60 - 79% = 0 

80 - 99% = 29 


Index IDX_GERAL_4 (7) 

Depth: 2, leaf buckets: 31, nodes: 18559 

Average data length: 0.00, total dup: 17962, max dup: 1151 

Fill distribution: 

0 - 19% = 0 

20 - 39% = 1 

40 - 59% = 0 

60 - 79% = 0 

80 - 99% = 30 


Index IDX_GERAL_5 (8) 

Depth: 2, leaf buckets: 30, nodes: 18559 

Average data length: 0.00, total dup: 17963, max dup: 1151 

Fill distribution: 

0 - 19% = 0 

20 - 39% = 1 

40 - 59% = 0 

60 - 79% = 0 

80 - 99% = 29 


Index IDX_GERAL_6 (9) 

Depth: 2, leaf buckets: 28, nodes: 18559 

Average data length: 0.00, total dup: 18553, max dup: 6594 

Fill distribution: 

0 - 19% = 0 

20 - 39% = 0 

40 - 59% = 1 

60 - 79% = 0 

80 - 99% = 27 


Index IDX_GERAL_7 (10) 

Depth: 2, leaf buckets: 69, nodes: 18559 

Average data length: 8.00, total dup: 0, max dup: 0 

Fill distribution: 

0 - 19% = 0 

20 - 39% = 0 

40 - 59% = 0 

60 - 79% = 0 

80 - 99% = 69 


Index IDX_NossoNumero (0) 

Depth: 2, leaf buckets: 70, nodes: 18559 

Average data length: 9.00, total dup: 0, max dup: 0 

Fill distribution: 

0 - 19% = 0 

20 - 39% = 0 

40 - 59% = 1 

60 - 79% = 0 

80 - 99% = 69 


Index PK_CHAVEG (11) 

Depth: 2, leaf buckets: 69, nodes: 18559 

Average data length: 8.00, total dup: 0, max dup: 0 

Fill distribution: 

0 - 19% = 0 

20 - 39% = 0 

40 - 59% = 0 

60 - 79% = 0 

80 - 99% = 69 



Mais detalhes sobre a lista de discussão lista