Which is the appropriate solution for this?

Your database has the ACCTG service configured for an accounting application running on a
middle tier. These service is used by the middle-tier applications to connect to the database by
using connection pools. The application has three modules LEDGER, ACCOUNTS, and BILLING.
You asked the developers to invoke the DBMS_APPLICATION_INFO.SET_MODULE procedure
to set the module name and action in the code for the application. You enabled tracing at the
service level by executing the following command:
SQL> exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE(‘ACCTG’);
You want to consolidate the trace output from the trace files created based on module. Which is
the appropriate solution for this?

Your database has the ACCTG service configured for an accounting application running on a
middle tier. These service is used by the middle-tier applications to connect to the database by
using connection pools. The application has three modules LEDGER, ACCOUNTS, and BILLING.
You asked the developers to invoke the DBMS_APPLICATION_INFO.SET_MODULE procedure
to set the module name and action in the code for the application. You enabled tracing at the
service level by executing the following command:
SQL> exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE(‘ACCTG’);
You want to consolidate the trace output from the trace files created based on module. Which is
the appropriate solution for this?

A.
Using trace files as input for the tkprof utility to consolidate the tracing of sessions for a module

B.
Using the trace file as input for the trcsess utility to consolidate and process the output for a
module

C.
Using the trcsess utility to consolidate all trace files into a single output file,which can then be
processed by the tkprof utility

D.
Using the trace file as input for the trcsess utility and creating output files that can directly be
used by the users for performance or debugging purposes



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Rodrigo

Rodrigo

http://docs.oracle.com/cd/B28359_01/server.111/b28274/sqltrace.htm


21.2 Using the trcsess Utility

The trcsess utility consolidates trace output from selected trace files based on several criteria:

– Session ID
– Client ID
– Service name
– Action name
– Module name

After trcsess merges the trace information into a single output file, the output file could be processed by TKPROF.