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.)

Question

Accepted Answer

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

Answer

A. Create database services for the applications, assign individual sessions created by the

Answer

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

Answer

D. Create database services for the applications, create a job class associated with the service,

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…

Question

Options

How the community answered

Community Discussion