Oracle
1Z0-117 · Question #110
1Z0-117 Question #110: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #110. The question stem and answer options stay visible for context.
Question
A new application module is deployed on middle tier and is connecting to your database. You want to monitor the performance of the SQL statements generated from the application. To accomplish this, identify the required steps in the correct order from the steps given below: 1. Use DBNMS_APPLICATION_INFO to set the name of the module 2. Use DBMS_MONITOR.SERV_MOD_ACT_STAT_ENABLE to enable statistics gathering for the module. 3. Use DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE to enable tracing for the service 4. Use the trcsess utility to consolidate the trace files generated. 5. Use the tkprof utility to convert the trace files into formatted output.
Options
- A1, 2, 3, 4, 5
- B2, 3, 1, 4, 5
- C3, 1, 2, 4, 5
- D1, 2, 4, 5
- E1, 3, 4, 5
- F2, 1, 4, 5
Unlock 1Z0-117 to see the answer
You've previewed enough free 1Z0-117 questions. Unlock 1Z0-117 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.