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