What action must you perform to achieve this?

Your database supports multiple applications. The applications run on the middle tier and use connection
pooling for connecting to the database.
You notice that the sessions created by the applications are competing for resources. You want to statistically
measure the workload and set priorities.
What action must you perform to achieve this? (Choose the best answer.)

Your database supports multiple applications. The applications run on the middle tier and use connection
pooling for connecting to the database.
You notice that the sessions created by the applications are competing for resources. You want to statistically
measure the workload and set priorities.
What action must you perform to achieve this? (Choose the best answer.)

A.
Create services for the applications and set a relative priority by assigning them to application users and
using the DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE procedure to trace the services.

B.
Create services for the applications and set a relative priority by assigning them to application users and
using the DBMS_MONITOR.SESSION_TRACE_ENABLE procedure to trace the services.

C.
Create services for the applications and set the relative priority of services within an instance by mapping
the services directly to consumer groups.

D.
Create services for the applications and set a relative priority by assigning them to application users.



Leave a Reply 0

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