What would you do to accomplish the task?

Your database supports many applications running on the middle tier. Many applications users create jobs for which you want to statistically measure workload as a part of performance management.
What would you do to accomplish the task?

Your database supports many applications running on the middle tier. Many applications users create jobs for which you want to statistically measure workload as a part of performance management.
What would you do to accomplish the task?

A.
Assign resource consumer group to jobs while creating the jobs.

B.
Create services for the applications and create jobs by using the DBMS_JOBS PL/SQL package.

C.
Query v$SESSION to gather statistics of the individual sessions for the workload created by the jobs.

D.
Create services for the applications, create job class associated with the service, and then create jobs by using the job classes.



Leave a Reply 0

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