Oracle
1Z0-054 · Question #184
You are managing an online transaction processing (OLTP) database with multiple applications. The applications support a large number of users and most of the applications execute groups of SQL that…
The correct answer is C. Monitor statistics and wait events collected for a MODULE and ACTION by performing service. See the full explanation below for the reasoning.
Question
You are managing an online transaction processing (OLTP) database with multiple applications. The applications support a large number of users and most of the applications execute groups of SQL that run together. Which option would you use to monitor the performance issues for users of these applications?
Options
- AMonitor statistics for individual sessions in an application by querying V$SESSION.
- BSpecify service-level thresholds and priorities for users of applications and monitor the alerts.
- CMonitor statistics and wait events collected for a MODULE and ACTION by performing service
- DConfigure application users as part of the resource consumer group and monitor the resource
How the community answered
(26 responses)- A4% (1)
- B12% (3)
- C81% (21)
- D4% (1)
Community Discussion
No community discussion yet for this question.