1Z0-054 · Question #143
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…
The correct answer is C. Using the trcsess utility to consolidate all trace files into a single output file, which can then be. See the full explanation below for the reasoning.
Question
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?
Options
- AUsing trace files as input for the tkprof utility to consolidate the tracing of sessions for a module
- BUsing the trace file as input for the trcsess utility to consolidate and process the output for a
- CUsing the trcsess utility to consolidate all trace files into a single output file, which can then be
- DUsing the trace file as input for the trcsess utility and creating output files that can directly be used
How the community answered
(41 responses)- A2% (1)
- B7% (3)
- C78% (32)
- D12% (5)
Community Discussion
No community discussion yet for this question.