alter system flush buffer_cache;
select * from v$bh;
SQL性能测试中为排除Buffer Cache对于测试结果影响时使用该方法强制Oracle重新执行物理读。
alter system flush shared_pool;
set autot trace statistic;
SET AUTOT[RACE] {OFF | ON | TRACE[ONLY]} [EXP[LAIN]] [STAT[ISTICS]]
alter system flush buffer_cache;
select * from v$bh;
SQL性能测试中为排除Buffer Cache对于测试结果影响时使用该方法强制Oracle重新执行物理读。
alter system flush shared_pool;
set autot trace statistic;
SET AUTOT[RACE] {OFF | ON | TRACE[ONLY]} [EXP[LAIN]] [STAT[ISTICS]]