Oracle Blocchi Corrotti: differenze tra le versioni
Jump to navigation
Jump to search
Nessun oggetto della modifica |
Nessun oggetto della modifica |
||
| Riga 1: | Riga 1: | ||
==Lista degli oggetti con blocchi corrotti== |
|||
SELECT DISTINCT owner, segment_name, partition_name, segment_type, tablespace_name, e.bytes/(1024*1024) mb |
SELECT DISTINCT owner, segment_name, partition_name, segment_type, tablespace_name, e.bytes/(1024*1024) mb |
||
from v$database_block_corruption dbc |
from v$database_block_corruption dbc |
||
Versione attuale delle 15:48, 20 mag 2026
Lista degli oggetti con blocchi corrotti
SELECT DISTINCT owner, segment_name, partition_name, segment_type, tablespace_name, e.bytes/(1024*1024) mb 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;