轻松掌握一些清内存对象及转储的常用命令

alter session set events 'immediate trace name flush_cache level 1';
alter session set events = 'immediate trace name flush_cache';

alter system flush buffer_cache

alter system flush shared_pool;

alter session set events 'immediate trace name heapdump level 2';

ALTER SESSION SET EVENTS 'immediate 
trace name LIBRARY_CACHE level n';

alter session set events 'immediate trace name controlf level 10';
alter session set events 'immediate trace name redohdr level 3';
ALTER SYSTEM DUMP LOGFILE '/opt/oracle9/oradata/testora9/redo01.log';
alter system dump datafile 3 block max 2 block min 4;