Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Packages

PROCEDURE DBMS_MONITOR.SERV_MOD_ACT_STAT_DISABLE

This procedure, which was introduced in Oracle 10.1, disables statistic collection for specified services and modules and also for specific actions.

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

The SERVICE_NAME and MODULE_NAME arguments are both mandatory. Note this differs from the functionality of SERV_MOD_ACT_TRACE_ENABLE

The ACTION_NAME can also be optionally specified.

For example to disable statistics collection for service name 'SERVICE1' and module 'MODULE1' use: 

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

To disable statistics collection for service name 'SERVICE1', module 'MODULE1' and action 'ACTION1' use: 

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