Oracle Blocchi Corrotti: differenze tra le versioni
Jump to navigation
Jump to search
(Creata pagina con " SELECT DISTINCT owner, segment_name, partition_name, segment_type, tablespace_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; Categoria:Database Categoria:Oracle") |
Nessun oggetto della modifica |
||
| Riga 1: | Riga 1: | ||
SELECT DISTINCT owner, segment_name, partition_name, segment_type, tablespace_name |
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; |
|||
[[Categoria:Database]] |
[[Categoria:Database]] |
||
Versione delle 11:59, 20 mag 2026
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;