Your database has the SRV1 service configured for an application that runs on middle-tier
application server. The application has multiple modules. You enable tracing at the service level
by executing the following command:
SQL > exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE (‘SRV1’);
The possible outcome and actions to aggregate the trace files are as follows:
1. The command fails because a module name is not specified.
2. A trace file is created for each session that is running the SRV1 service.
3. An aggregated trace file is created for all the sessions that are running the SRV1 service.
4. The trace files may be aggregated by using the trcess utility.
5. The trace files be aggregated by using the tkprof utility.
Identify the correct outcome and the step to aggregate by using tkprof utility?
A.
1
B.
2 and 4
C.
2 and 5
D.
3 and 4
E.
3 and 5
Explanation:
Tracing information is present in multiple trace files and you must use the trcsess
tool to collect it into a single file.
Incorrect:
Not 1: Parameter service_name
Name of the service for which tracing is enabled.module_name
Name of the MODULE. An optional additional qualifier for the service.
Note:
* The procedure enables a trace for a given combination of Service, MODULE and ACTION name.
The specification is strictly hierarchical: Service Name or Service Name/MODULE, or Service
Name, MODULE, and ACTION name must be specified. Omitting a qualifier behaves like a wildcard, so that not specifying an ACTION means all ACTIONs. Using the ALL_ACTIONS constant
achieves the same purpose.
* SERV_MOD_ACT_TRACE_ENABLE Procedure
This procedure will enable SQL tracing for a given combination of Service Name, MODULE and
ACTION globally unless an instance_name is specified.
* DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE(
service_name IN VARCHAR2,
module_name IN VARCHAR2 DEFAULT ANY_MODULE,
action_name IN VARCHAR2 DEFAULT ANY_ACTION,
waits IN BOOLEAN DEFAULT TRUE,
binds IN BOOLEAN DEFAULT FALSE,
instance_name IN VARCHAR2 DEFAULT NULL);
Correct
Answer is “A”. Module name is a required parameter which is missing here.
http://docs.oracle.com/database/121/ARPLS/d_monitor.htm#ARPLS67170
Correct —> B
A is incorrect, because if you do not specify a module_name then a default value is passed ALL_MODULES.
Please refer to sintax:
Syntax
DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE(
service_name IN VARCHAR2,
module_name IN VARCHAR2 DEFAULT ANY_MODULE,
In adition could to run the script and no error was displayed.
http://www.dba-oracle.com/t_trcsess_tips.htm
The trcsess command-line utility offers the DBA a way to combine or consolidate several trace files into a single trace file based upon the following criteria:
Session Id
Client Id
Service name
Action name
Module name
Thus, B (2 per Paul above and 4).
B