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