You get complaints from users of several different applications that performance has
degraded over time.
These applications run in this configuration:
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 configurethe 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
A,D,E
BCF
B,C,F
======================
… the objective is to Check ALL resource allocations to make sure they are all appropriate.
—————————–
Avoiding Database Deployment Scaling
Analyzing database performance could point to short-term intermittent load peaks or occasional competition between PDBs or within a PDB for resources.
Before scaling up the deployment database, you can examine the resources allocated and required by the different consumers within the database.
Resource Manager can allocate resources (CPU) between PDBs, and among users inside a PDB by allocating:
>>> Shares of the system resources allocated to PDBs within the CDB so that resources are allocated fairly to all PDBs or more resources to the more important PDBs
>>> Resources to consumer groups within the non-CDB or PDB
CDE
A,D,E