
Oracle 11g表的碎片率诊断
在Oracle中,有些表由于频繁的插入和删除数据,导致高水位过高,表的碎片也很高,如何判断呢? drop table test purge; create table test as select * from dba_objects; insert into test select * from test; insert into test select * from test; commit
在Oracle中,有些表由于频繁的插入和删除数据,导致高水位过高,表的碎片也很高,如何判断呢? drop table test purge; create table test as select * from dba_objects; insert into test select * from test; insert into test select * from test; commit