A database instance is configured in the shared server mode and it supports multiple applications running on a middle tier. These applications connect to the database using different services. You…

Question

Options

• AThe statistics are gathered for all the modules and actions within the service.
• BThe statistics are collected at the session level for all sessions connected using the service.
• CThe statistics are aggregated and stored in the V$SERV_MOD_ACT_STATS view.
• DThe statistics are gathered for all the modules using the service only when DBMS_APPLICATION_INFO.
• EStatistics gathering is enabled only for the subsequent sessions using the service.
• FThe statistics are gathered for all the applications using the service only when DBMS_APPLICATION_INFO.

• A
  78% (50)
• D
  3% (2)
• E
  8% (5)
• F
  11% (7)

Explanation

SERV_MOD_ACT_STAT_ENABLE Procedure This procedure enables statistic gathering for a given combination of Service Name, MODULE and ACTION. Calling this procedure enables statistic gathering for a hierarchical combination of Service name, MODULE name, and ACTION name on all instances for the same database. Statistics are accessible by means of the V$SERV_MOD_ACT_STATS view. DBMS_MONITOR.SERV_MOD_ACT_STAT_ENABLE( service_name IN VARCHAR2, module_name IN VARCHAR2, action_name IN VARCHAR2 DEFAULT ALL_ACTIONS); Parameter, Description Name of the service for which statistic aggregation is enabled module_name Name of the MODULE. An additional qualifier for the service. It is a required parameter. Name of the ACTION. An additional qualifier for the Service and MODULE name. Omitting the parameter (or supplying ALL_ACTIONS constant) means enabling aggregation for all Actions for a given Server/Module combination. In this case, statistics are aggregated on the module level. SERV_MOD_ACT_STAT_ENABLE Procedure

No community discussion yet for this question.