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.
3 and 5
B.
1
C.
2 and 4
D.
2 and 5
E.
3 and 4
https://docs.oracle.com/database/121/TGSQL/tgsql_trace.htm#TGSQL95001
Tools for End-to-End Application Tracing
The TRCSESS command-line utility consolidates tracing information based on specific criteria. The SQL Trace facility and TKPROF are two basic performance diagnostic tools that can help you accurately assess the efficiency of the SQL statements an application runs. For best results, use these tools with EXPLAIN PLAN rather than using EXPLAIN PLAN alone. After tracing information is written to files, you can consolidate this data with the TRCSESS utility, and then diagnose it with TKPROF or SQL Trace.
C