Which option would you use to monitor the performance issues for users of these applications?

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?

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.



Leave a Reply 1

Your email address will not be published. Required fields are marked *