You created two services HR and FINANCE on a single instance database. These services are
used by the middle-tier applications to connect to the database by using connection pools. The
applications have various modules and you asked the developers to invoke the
DBMS_APPLICATION_INFO.SET_MODULE procedure to set the module name and action in the
code for the application.
As part of performance management, you want to gather statistics for these modules and see the
amount of workload created by these modules. What would you recommend to accomplish the
task?
A.
Using the DBMS_MONITOR.SERV_MOD_ACT_STAT_ENABLE procedure to collect statistics
for a module and querying the V$SERVICE_EVENT view
B.
Using the DBMS_MONITOR.SERV_MOD_ACT_STAT_ENABLE procedure to collect statistics
for a module and querying the V$SERVICE_STATS view
C.
Using the DBMS_MONITOR.SERV_MOD_ACT_STAT_ENABLE procedure to collect statistics
for a module and querying the V$SERV_MOD_ACT_STATS view
D.
Querying the V$SERVICE_STATS view because the statistics for the modules are collected
automatically when you invoke the DBMS_APPLICATION_INFO.SET_MODULE procedure
http://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_monitor.htm
SERV_MOD_ACT_STAT_ENABLE – enables statistic gathering for a given combination of Service Name, MODULE and ACTION. Statistics are accessible by means of the V$SERV_MOD_ACT_STATS view.
Answer A and B are wrong.
Answer C is correct.
Answer D is incorrect since from the beginning because it initially states that V$SERVICE_STATS has to be queried.
when using DBMS_MONITOR.SRRV_MOD_ACT_STAT_ENABLE to collect stats info, you will need to query V$SERV_MOD_ACT_STATS view
C is right