ENABLE MMON TRACE IN ORACLE

To enable trace for MMON process for monitoring the auto purging mechanism of cleaning up SYSAUX tablespace, first execute dbms_monitor package

kish@exdbx<>BEGIN
dbms_monitor.serv_mod_act_trace_enable
(service_name=>'SYS$BACKGROUND',
module_name=>'MMON_SLAVE',
action_name=>'AWR Auto-Purge Slave Action',
waits => true,
binds => true);
END;
/
PL/SQL procedure successfully completed.

Check if the trace is enabled

kish@exdbx<>col PRIMARY_ID for a20
kish@exdbx<>col QUALIFIER_ID1 for a20
kish@exdbx<>col QUALIFIER_ID2 for a20
kish@exdbx<>select * from dba_enabled_traces;

TRACE_TYPE            PRIMARY_ID           QUALIFIER_ID1        QUALIFIER_ID2        WAITS BINDS PLAN_STATS INSTANCE_NAME
--------------------- -------------------- -------------------- -------------------- ----- ----- ---------- ----------------
SERVICE_MODULE_ACTION SYS$BACKGROUND       MMON_SLAVE           AWR Auto-Purge Slave TRUE  TRUE  FIRST_EXEC NULL
                                                                 Action

To disable MMON trace

kish@exdbx<>
BEGIN
dbms_monitor.serv_mod_act_trace_disable
(service_name=>'SYS$BACKGROUND',
module_name=>'MMON_SLAVE',
action_name=>'AWR Auto-Purge Slave Action'
);
END;
/
kish@exdbx<>  2    3    4    5    6    7    8
PL/SQL procedure successfully completed.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s