You get complaints from users of several different applications that performance has degraded over time.
These applications run in this configuration:
1. There are three different databases and database instances.
2. Two of the poorly performing applications run in the same Pluggable Database (PDB) in an Oracle 12c multitenant Container Database (CDB) with four PDBs.
3. One of the poorly performing applications runs in a different PDB in the same CDB.
4. One of the poorly performing applications runs in an Oracle 12c non-CDB, which also hosts other applications.
5. You have the Oracle Resource Manager configured for the CDB, all PDBs, and the non-CDB.
6. Each application has a separate consumer group associated with the sessions that are running that application.
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 three should you check and possibly reconfigure to avoid the need to scale up the DBaaS instance?
A.
Check the shares allocated only to the consumer group in the non-CDB that is used by the poorly performing application.
B.
Check the shares allocated to all consumer groups in the non-CDB.
C.
Check the CDB plan to configure the shares allocated to all PDBs, including the PDB that contains the two poorly performing applications.
D.
Check the PDB plan for the PDB that is hosting the two poorly performing applications.
E.
Check the CDB plan only to configure the shares allocated to the PDB that contains the two poorly performing applications.
F.
Check the PDB plan for all the PDBs in the CDB, including the PDB that is hosting the two poorly performing applications.
Explanation:
https://docs.oracle.com/database/121/ADMIN/cdb_dbrm_em.htm
Not sure, but C is better answer for me than E. F vs.D. B vs. A.
Correct: B,C,F.
I have taken the exam and answered BCF and it was correct.
I would go too for B,C,F
B,C,D is correct