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?
A.
Monitor statistics for individual sessions in an application by querying V$SESSION.
B.
Specify service-level thresholds and priorities for users of applications and monitor the alerts.
C.
Monitor statistics and wait events collected for a MODULE and ACTION by performing service aggregation.
D.
Configure application users as part of the resource consumer group and monitor the resource usage statistics for the resource consumer group.