awr mmon trace 뜨기

1. trace 설정

begin 
dbms_monitor.serv_mod_act_trace_enable(service_name=>'SYS$BACKGROUND', 
module_name=>'MMON_SLAVE', 
action_name=>'Auto-Purge Slave Action', 
binds=>TRUE); 
end; 
/ 

2. trace 비활성화 및 trace gathering

begin 
dbms_monitor.serv_mod_act_trace_disable(service_name=>'SYS$BACKGROUND', 
module_name=>'MMON_SLAVE', 
action_name=>'Auto-Purge Slave Action'); 
end; 
/ 

and 

alter session set events 'immediate trace name awr_test level 2'; 
alter session set events 'immediate trace name awr_test level 4'; --turns off all tracing.