ORA-01578: ORACLE data block corrupted sysaux
Hello,
I noticed in the alert.log messages: ORA-01578: ORACLE data block corrupted (file # ORA-01578: ORACLE data block corrupted (file # 3, block # 576939)
File 3 is SYSAUX datafile
I ran the following queires
SQL> select * from v$database_block_corruption;
FILE# BLOCK# BLOCKS CORRUPTION_CHANGE# CORRUPTIO CON_ID
---------- ---------- ---------- ------------------ --------- ----------
3 576939 1 0 CHECKSUM 0
SQL> SELECT tablespace_name, segment_type, owner, segment_name FROM dba_extents WHERE file_id=3 and 576939 BETWEEN block_id AND block_id + blocks - 1;
TABLESPACE_NAME SEGMENT_TYPE OWNER SEGMENT_NAME
------------------------------ ------------------ -------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------
SYSAUX TABLE SYS WRH$_SQL_PLAN
How i understand a corrupted block is in the WRH$_SQL_PLAN?