[firebase-br] database statistic

Ter Mar 14 10:47:05 -03 2006

As duas primeiras edições da DBFreeMagazine trazem um artigo sobre o gstat.

www.dbfreemagazine.com.br

[]s
Cantu (Membro do TeamFB - FireBase)
http://www.warmboot.com.br
FireBase - http://www.FireBase.com.br

M> bom dia a todos....

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

M> obrigado.

M> Database header page information: 

M> Flags 0 

M> Checksum 12345 

M> Generation 29 

M> Page size 4096 

M> ODS version 10.1 

M> Oldest transaction 6 

M> Oldest active 7 

M> Oldest snapshot 7 

M> Next transaction 23 

M> Bumped transaction 1 

M> Sequence number 0 

M> Next attachment ID 0 

M> Implementation ID 19 

M> Shadow count 0 

M> Page buffers 0 

M> Next header page 0 

M> Database dialect 3 

M> Creation date Mar 14, 2006 9:16:36 

M> Attributes 

M> Variable header data: 

M> Sweep interval: 20000 

M> *END* 

M> Database file sequence: 

M> File /home//Dados/Cart.gdb is the only file 

M> Database log page information: 

M> Creation date 

M> Log flags: 2 

M> No write ahead log 

M> Next log page: 0 

M> Variable log data: 

M> Control Point 1: 

M> File name: 

M> Partition offset: 0 Seqno: 0 Offset: 0 

M> Control Point 2: 

M> File name: 

M> Partition offset: 0 Seqno: 0 Offset: 0 

M> Current File: 

M> File name: 

M> Partition offset: 0 Seqno: 0 Offset: 0 

M> *END* 

M> GERAL (153) 

M> Primary pointer page: 447, Index root page: 448 

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

M> Fill distribution: 

M> 0 - 19% = 1 

M> 20 - 39% = 0 

M> 40 - 59% = 0 

M> 60 - 79% = 0 

M> 80 - 99% = 2963 

M> Index IDX_CODBAN (2) 

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

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

M> Fill distribution: 

M> 0 - 19% = 0 

M> 20 - 39% = 0 

M> 40 - 59% = 1 

M> 60 - 79% = 0 

M> 80 - 99% = 27 

M> Index IDX_Codbarracorreio (1) 

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

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

M> Fill distribution: 

M> 0 - 19% = 0 

M> 20 - 39% = 0 

M> 40 - 59% = 1 

M> 60 - 79% = 0 

M> 80 - 99% = 45 

M> Index IDX_Docorrenc (3) 

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

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

M> Fill distribution: 

M> 0 - 19% = 0 

M> 20 - 39% = 0 

M> 40 - 59% = 1 

M> 60 - 79% = 0 

M> 80 - 99% = 27 

M> Index IDX_GERAL_1 (4) 

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

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

M> Fill distribution: 

M> 0 - 19% = 0 

M> 20 - 39% = 0 

M> 40 - 59% = 1 

M> 60 - 79% = 0 

M> 80 - 99% = 27 

M> Index IDX_GERAL_2 (5) 

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

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

M> Fill distribution: 

M> 0 - 19% = 0 

M> 20 - 39% = 0 

M> 40 - 59% = 1 

M> 60 - 79% = 0 

M> 80 - 99% = 28 

M> Index IDX_GERAL_3 (6) 

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

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

M> Fill distribution: 

M> 0 - 19% = 1 

M> 20 - 39% = 0 

M> 40 - 59% = 0 

M> 60 - 79% = 0 

M> 80 - 99% = 29 

M> Index IDX_GERAL_4 (7) 

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

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

M> Fill distribution: 

M> 0 - 19% = 0 

M> 20 - 39% = 1 

M> 40 - 59% = 0 

M> 60 - 79% = 0 

M> 80 - 99% = 30 

M> Index IDX_GERAL_5 (8) 

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

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

M> Fill distribution: 

M> 0 - 19% = 0 

M> 20 - 39% = 1 

M> 40 - 59% = 0 

M> 60 - 79% = 0 

M> 80 - 99% = 29 

M> Index IDX_GERAL_6 (9) 

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

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

M> Fill distribution: 

M> 0 - 19% = 0 

M> 20 - 39% = 0 

M> 40 - 59% = 1 

M> 60 - 79% = 0 

M> 80 - 99% = 27 

M> Index IDX_GERAL_7 (10) 

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

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

M> Fill distribution: 

M> 0 - 19% = 0 

M> 20 - 39% = 0 

M> 40 - 59% = 0 

M> 60 - 79% = 0 

M> 80 - 99% = 69 

M> Index IDX_NossoNumero (0) 

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

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

M> Fill distribution: 

M> 0 - 19% = 0 

M> 20 - 39% = 0 

M> 40 - 59% = 1 

M> 60 - 79% = 0 

M> 80 - 99% = 69 

M> Index PK_CHAVEG (11) 

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

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

M> Fill distribution: 

M> 0 - 19% = 0 

M> 20 - 39% = 0 

M> 40 - 59% = 0 

M> 60 - 79% = 0 

M> 80 - 99% = 69 
M> ______________________________________________
M> FireBase-BR (www.firebase.com.br) - Hospedado em www.bavs.com.br
M> Para editar sua configuração na lista, use o endereço
M> http://mail.firebase.com.br/mailman/listinfo/lista_firebase.com.br
M> Para consultar mensagens antigas: http://firebase.com.br/pesquisa