有时候对表进行了大量的更新操作或者在表中增加了一列含有默认值的列,那么就有可能出现表的行迁移情况,这种情况造成了对数据访问的过多的逻辑读HR@orcl>create table employee_test as select * from employees;表已创建。HR@orcl>desc employee_test名称 ...【阅读全文】
How to identify all the Corrupted Objects in the Database with RMAN [ID 472231.1]SELECT e.owner, e.segment_type, e.segment_name, e.partition_name, c.file# , greatest(e.block_id, c.block#) corr_start_block# , least(e.block_id+e.blocks-1, c.block#+c.blocks-1) ...【阅读全文】