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…

Question

Options

• AUse all trace files as input for the tkprof utility to consolidate the trace files for a module.
• BUse one trace file at a time as input for the trcess utility and use tkprof utility to consolidate all the output
• CUse the trcess utility to consolidate all trace files into a single output file, which can then be processed by
• DUse the tkprof utility to consolidate the trace files and create an output that can directly be used for diagnostic

• A
  4% (2)
• B
  9% (4)
• C
  85% (40)
• D
  2% (1)

Explanation

• 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

No community discussion yet for this question.