ORA-600 [6101] “insert into leaf block (undo)“

问题

解决方案

MOS

2.1 查看索引对象名称

select owner,object_name from dba_objects where object_id=&object_id;

查看索引对象名称

2.2 表空间 -> 用户 -> index name

查看表空间名称

select file_id,file_name,tablespace_name from dba_data_files where file_id=7;

Oracle查看表空间对象

查看对应索引名称

select owner,segment_name,segment_type from dba_extents  
    where file_id = 7 and 6427 between block_id and block_id+blocks-1;

11g备库不能查？？？

触发器？？？

select trigger_name from all_triggers where table_name='XXX';

2.3 分析索引

ANALYZE INDEX <index name>/owner.segment_name VALIDATE STRUCTURE ONLINE;

查看索引大小

select owner,segment_name,bytes/1024/1024/1024 from dba_segments where segment_name='xxxx';

oracle查找索引坏块

处理索引坏块

backup validate check logical datafile 7;

set lines 120

select * from v$database_block_corruption

2.4 重建索引

重建索引