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.