有时可能需要手工强制刷新buffer cache
在9i中使用:
当前session
alter session set events ‘immediate trace name flush_cache level 1′;
alter session set events = ‘immediate trace name flush_cache’;
全局
alter system set events = ‘immediate trace name flush_cache’;
在10g中使用:
buffer cache
alter system flush buffer_cache;
shared pool
alter system flush shared_pool;