You are administering a database that supports a mixed workload. Many applications are running on the middle tier that u
Posted: Sun Jun 11, 2023 3:51 pm
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.
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.