Your database has the OLTP_SRV service configured for an OLTP application running on a
middle tier. This service is used to connect to the database by using connection pools. The
application has three modules. You enabled tracing at the service by executing the following
command:
SQL exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE (‘OLTP_SRV’);
What is the correct method of consolidating the trace files generated by the procedure?
A.
Use all trace files as input for the tkprof utility to consolidate the trace files for a module.
B.
Use one trace file at a time as input for the trcess utility and use tkprof utility to consolidate all
the output files for a module.
C.
Use the trcess utility to consolidate all trace files into a single output file, which can then be
processed by the tkprof utility.
D.
Use the tkprof utility to consolidate the trace files and create an output that can directly be used
for diagnostic purposes.
Explanation:
Note:
* Oracle provides the trcsess command-line utility that consolidates tracing information based on
specific criteria.
The SQL Trace facility and TKPROF are two basic performance diagnostic tools that can help you
monitor applications running against the Oracle Server.
Note: SERV_MOD_ACT_TRACE_ENABLE Procedure
Enables SQL tracing for a given combination of Service Name, MODULE and ACTION globally
unless an instance_name is specified
Reference: Oracle Database Performance Tuning Guide
I think D
C correct
After theSQL Trace facility has generated trace files, you can:
– Run TKPROF on each individual trace file, producing several formatted output files, one for each session.
– Concatenate the trace files, and then run TKPROF on the result to produce a formatted output file for the entire instance.
– Run the trcsess command-line utility to consolidate tracing information from several trace files, then run TKPROF on the result.