DBA Data[Home] [Help]

VIEW: SYS.V_$DATABASE_BLOCK_CORRUPTION

Source

View Text - Preformatted

select "FILE#","BLOCK#","BLOCKS","CORRUPTION_CHANGE#","CORRUPTION_TYPE","CON_ID" from
   v$database_block_corruption
View Text - HTML Formatted

SELECT "FILE#"
, "BLOCK#"
, "BLOCKS"
, "CORRUPTION_CHANGE#"
, "CORRUPTION_TYPE"
, "CON_ID" FROM V$DATABASE_BLOCK_CORRUPTION