You get complaints from users of several different applications that performance has degraded over time.
These applications run in this configuration:
1. There is one database and database instance, which is an Oracle 12c multitenant Container Database (CDB) with five Pluggable Databases (PDBs).
2. One of the poorly performing applications run in one of the PDBs.
3. One of the poorly performing applications runs in a different PDB in the same CDB.
4. You have the Oracle Resource Manager configured for the CDB only.
5. Each PDB has all sessions in one consumer group.
A check of wait events for the sessions belonging to these applications shows that the sessions are waiting longer and that there are more sessions from other
applications in the same database instance.
You wish to avoid scaling up your Database as a Service (DBaaS) instance in Oracle Cloud.
Which four should you check and possibly reconfigure to avoid the need to scale up the DBaaS instance?
A.
Modify the users that are using each application so that their sessions are associated with the correct consumer group in the PDB that is hosting their application.
B.
Check the CDB plan to configure the shares allocated to all PDBs, including the PDBs that contain the two poorly performing applications.
C.
Check the CDB plan only to configure the shares allocated to the PDBs that contain the two poorly performing applications.
D.
Create separate consumer groups for the sessions for all applications in the PDB plans for the PDBs that are hosting the two poorly performing applications.
E.
Check the PDB plan for all the PDBs in the CDB, including the PDB that is hosting the two poorly performing applications.
F.
Create a PDB plan for each PDB in the CDB that has poorly performing applications.
G.
Create a separate CDB plan for each PDB that has poorly performing applications.