What is SERV_MOD_ACT_STAT_ENABLE?

What is SERV_MOD_ACT_STAT_ENABLE?

Rating:

SERV_MOD_ACT_STAT_ENABLE is a procedure of the DBMS_MONITOR package. This procedure is called to enable statistic gathering for a given hierarchical combination of Service Name, Module, and Action on all database instances. The V view is used to access the statistics.

The syntax to call the procedure is given below:

DBMS_MONITOR.SERV_MOD_ACT_STAT_ENABLE (
   service_name IN VARCHAR2,
   module_name IN VARCHAR2,
   action_name IN VARCHAR2);

A description of each parameter is given below:

• service_name: It specifies the name of the service for which statistic aggregation is enabled.
• module_name: It specifies the name of the module, and serves as an additional qualifier for the specified service. It is a required parameter.
• action_name: It specifies the name of the action, and serves as an additional qualifier for the service and module name. If the parameter is not specified or ALL_ACTIONS constant is supplied, it enables aggregation for all actions for a given Server/Module.

Rating: