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?

Question

Accepted Answer

A. Modify the users that are using each application so that their sessions are associated with the B. Check the CDB plan to configure the shares allocated to all PDBs, including the PDBs that contain D. Create separate consumer groups for the sessions for all applications in the PDB plans for the F. Create a PDB plan for each PDB in the CDB that has poorly performing applications.

Answer

C. Check the CDB plan only to configure the shares allocated to the PDBs that contain the two poorly

Answer

E. Check the PDB plan for all the PDBs in the CDB, including the PDB that is hosting the two poorly

Answer

G. Create a separate CDB plan for each PDB that has poorly performing applications.

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…

Question

Options

How the community answered

Community Discussion