Which action would you take to achieve this?

You are administering a database that supports a mixed workload. Many applications are
running on the middle tier that use connection pools to connect to the database instance.
Application users perform OLTP operations during the day and another application
performs batch job operations at night. You want to measure and prioritize the two
workloads. Which action would you take to achieve this?(Choose the best answer.)

You are administering a database that supports a mixed workload. Many applications are
running on the middle tier that use connection pools to connect to the database instance.
Application users perform OLTP operations during the day and another application
performs batch job operations at night. You want to measure and prioritize the two
workloads. Which action would you take to achieve this?(Choose the best answer.)

A.
Create database services for the applications, assign individual sessions created by the
applications to consumer groups, and then set a priority.

B.
Assign profiles to users running the batch operations and make sure that a priority is set
for resource limits in profiles.

C.
Create database services for the applications and assign different profiles to the sessions
to set a relative priority for resource usage.

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



Leave a Reply 2

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