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');