nerdexam
Oracle

1Z0-160 · Question #48

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…

The correct answer is A. Check the shares allocated only to the consumer group in the non-CDB that is used by the poorly 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. https://docs.oracle.com/database/121/ADMIN/cdb_dbrm_em.htm

Monitoring and Tuning Databases

Question

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?

Options

  • ACheck the shares allocated only to the consumer group in the non-CDB that is used by the poorly
  • BCheck the shares allocated to all consumer groups in the non-CDB.
  • CCheck the CDB plan to configure the shares allocated to all PDBs, including the PDB that contains
  • DCheck the PDB plan for the PDB that is hosting the two poorly performing applications.
  • ECheck the CDB plan only to configure the shares allocated to the PDB that contains the two poorly
  • FCheck the PDB plan for all the PDBs in the CDB, including the PDB that is hosting the two poorly

How the community answered

(32 responses)
  • A
    75% (24)
  • B
    3% (1)
  • C
    6% (2)
  • F
    16% (5)

Explanation

https://docs.oracle.com/database/121/ADMIN/cdb_dbrm_em.htm

Topics

#Resource Manager#CDB plan#PDB plan#consumer groups

Community Discussion

No community discussion yet for this question.

Full 1Z0-160 Practice