oracle 坏块信息

select b.tablespace_name,a.file#,b.file_name,a.block#,a.blocks,a.CORRUPTION_CHANGE#,a.CORRUPTION_TYPE,con_id from v$database_block_corruption a,dba_data_files b where a.FILE#=b.file_id order by b.tablespace_name,a.file#,a.block#;