8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
Script: database_block_corruption.sql
( Download Script )
-- ----------------------------------------------------------------------------------- -- File Name : https://oracle-base.com/dba/11g/database_block_corruption.sql -- Author : Tim Hall -- Description : Displays the users who currently have admin privileges. -- Requirements : Access to the V$ and DBA views. -- Assumes a RMAN VALIDATE has been run against a datafile, tablespace -- or the whole database before this query is run. -- Call Syntax : @database_block_corruption -- Last Modified: 29/11/2018 -- ----------------------------------------------------------------------------------- COLUMN owner FORMAT A30 COLUMN segment_name FORMAT A30 SELECT DISTINCT owner, segment_name FROM v$database_block_corruption dbc JOIN dba_extents e ON dbc.file# = e.file_id AND dbc.block# BETWEEN e.block_id and e.block_id+e.blocks-1 ORDER BY 1,2;