Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Packages

PROCEDURE DBMS_MONITOR.SERV_MOD_ACT_TRACE_DISABLE

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 mandotory

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

Finally in a RAC environment, the INSTANCE_NAME argument can be used to speciify 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');