[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