Tom is the DBA of DNX Bank. The users of the banking system are complaining that all debit transactions are taking too long to execute. The details of the application used for this purpose are listed below:
Application – Bank_DNX to access banking accounts
Module – CUSTLEDGER
Action DEBIT_ENTRY
Which command should Tom execute in order to gather static for the states problem?
A.
EXECUTE DBMS_MONITOR.SERV_MOD_ACT_STAT_ENABLE
(‘BANK_DNX’,’CUSTLEDGER’);
B.
EXECUTE DBMS_MONITOR.SERV_MOD_ACT_STAT_ENALBLE
(‘BANK_DNX’);
C.
EXECUTE DBMS_MONITOR.SERV_MOD_ACT_STAT_ENABLE
(‘DEBIT_ENTRY’);
D.
EXECUTE DBMS_MONITOR.SERV_MOD_ACT_STAT_ENABLE
(‘BANK_DNX’,’CLUSTLEDGER’,’DEBIT_ENTRY’);
E.
EXECUTE DBMS_MONITOR.SERV_MOD_ACT_STAT_ENABLE
(‘CLUSTLEDGER’,’DEBIT_ENTRY’);
Explanation:
DBMS_MONITOR.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.
Syntax
DBMS_MONITOR.SERV_MOD_ACT_STAT_ENABLE(
service_name IN VARCHAR2,
module_name N VARCHAR2,
action_name IN VARCHAR2 DEFAULT ALL_ACTIONS);
Parameters
service_name 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.action_name 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.REF: Oracle(r) Database PL/SQL Packages and Types Reference