› Fóruns › Banco de dados Oracle › Coleta de Estatisticas Gerando erro ORA-03113 › Coleta de Estatisticas Gerando erro ORA-03113
Passei o DBV, por enquanto, apenas no datafile que ta a tabela com bloco ruim, tem mais datafiles na TS, mas ainda nao passei…
Outra coisa, rodei o DBV com a TS online.
Resultado:
DBVERIFY – Verification starting : FILE = M:xxyyyyDatafile02.DBF
Block Checking: DBA = 29378501, Block Type = KTB-managed data block
data header at 0x10a827c
[b]kdbchk: the amount of space used is not equal to block size
used=7378 fsc=0 avsp=1177 dtl=8064[/b]
Page 18373 failed with check code 6110
……….
DBVERIFY – Verification complete
Total Pages Examined : 384000
Total Pages Processed (Data) : 237784
Total Pages Failing (Data) : 1
Total Pages Processed (Index): 143372
Total Pages Failing (Index): 0
Total Pages Processed (Other): 1804
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 1040
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Highest block SCN : 2089558116 (0.2089558116)