Your database has the HR and Reporting applications. The HR application does most of the transactions on the database and the Reporting application does most of the batch processing operations.The Reporting application has more workload during nonpeak hours. Both the HR and Reporting applications run on the middle tier using connection pooling for connecting to database.You want to statistically measure the workload generated by both the applications and set priority for the workload generated by the applications.
Which option would help you achieve this?
A.
Assigning individual sessions created by the applications to consumer groups and setting relative priority
B.
Assigning profiles to individual sessions created by the applications to set the relative priority for the resource usage
C.
Creating services for the applications and setting the relative priority of services within an instance by binding the services directly to consumer groups
D.
Creating services for the applications and assigning different profiles to the sessions created by the sessions to set the relative priority for the resource usage