Oracle Database 12c: Performance Management and Tuning — Question 8

Which two actions should you take to monitor the throughput generated by the modules of an application? (Choose two.)

Answer options

• A. Use the Resource Manager.
• B. Enable SQL Trace at the session level.
• C. Create a service.
• D. Use a dedicated server configuration.
• E. Use the DBMS_APPLICATION_INFO package to define the current module and action so that they appear in V$SESSION.

Correct answer: A, B

Explanation

The correct answers, A and B, are effective methods for monitoring application throughput. The Resource Manager helps allocate resources efficiently, while SQL Trace captures detailed session activity. Options C, D, and E do not directly focus on monitoring throughput, making them less suitable for this purpose.