DBMS_MONITOR.SERV_MOD_ACT_TRACE_DISABLE Procedure

This procedure, which was introduced in Oracle 10.1, disables event 10046 trace for specified services and also for specified modules and actions.

Argument Name Type In/Out Default?
SERVICE_NAME VARCHAR2 IN  
MODULE_NAME VARCHAR2 IN DEFAULT
ACTION_NAME VARCHAR2 IN DEFAULT
INSTANCE_NAME BOOLEAN IN DEFAULT

The SERVICE_NAME argument is mandatory

The MODULE_NAME can be optionally specified

The ACTION_NAME can also be optionally specified. If the ACTION_NAME is specified then the MODULE_NAME must also be specified

In a RAC environment, the INSTANCE_NAME argument can be used to specify the instance on which trace will be disabled.

For example to disable event 10046 trace for service name 'SERVICE1' use:

EXECUTE dbms_monitor.serv_mod_act_trace_disable (service_name=>'SERVICE1');

To disable event 10046 trace for service name 'SERVICE1' and module 'MODULE1' use:

EXECUTE dbms_monitor.serv_mod_act_trace_disable 
(service_name=>'SERVICE1',module_name=>'MODULE1');

To disable event 10046 trace for service name 'SERVICE1', module 'MODULE1' and action 'ACTION1' use:

EXECUTE dbms_monitor.serv_mod_act_trace_disable 
(service_name=>'SERVICE1',module_name=>'MODULE1',action_name=>'ACTION1');