nerdexam
Oracle

1Z0-062 · Question #97

Which three resources might be prioritized between competing pluggable databases when creating a multitenant container database plan (CDB plan) using Oracle Database Resource Manager?

The correct answer is A. Maximum Undo per consumer group C. Parallel server limit D. CPU. Oracle Database Resource Manager CDB plans can prioritize specific resources between competing PDBs. The three resources available at the CDB level are CPU, parallel server limit, and maximum undo per consumer group.

Managing Performance

Question

Which three resources might be prioritized between competing pluggable databases when creating a multitenant container database plan (CDB plan) using Oracle Database Resource Manager?

Options

  • AMaximum Undo per consumer group
  • BMaximum Idle time
  • CParallel server limit
  • DCPU
  • EExadata I/O
  • FLocal file system I/O

How the community answered

(45 responses)
  • A
    84% (38)
  • B
    4% (2)
  • E
    2% (1)
  • F
    9% (4)

Why each option

Oracle Database Resource Manager CDB plans can prioritize specific resources between competing PDBs. The three resources available at the CDB level are CPU, parallel server limit, and maximum undo per consumer group.

AMaximum Undo per consumer groupCorrect

Maximum Undo per consumer group is a valid CDB resource plan directive that limits the amount of undo space a PDB's sessions can consume. This prevents a single PDB from exhausting shared undo space in the CDB, ensuring fair access to undo resources across all pluggable databases.

BMaximum Idle time

Maximum Idle Time is a consumer group-level directive within a PDB plan used to disconnect idle sessions, not a resource type used to prioritize resources between competing PDBs at the CDB level.

CParallel server limitCorrect

The PARALLEL_SERVER_LIMIT directive in a CDB plan caps the percentage of parallel execution servers a PDB may use at any time. By setting this limit per PDB, the CDB resource plan ensures that one PDB cannot consume all available parallel slaves, preserving parallel query resources for other PDBs.

DCPUCorrect

CPU is the foundational resource managed by CDB plans, controlled through share-based allocation and utilization limit directives. These settings determine the proportional CPU time each PDB receives during contention, making CPU management the primary purpose of CDB resource plans.

EExadata I/O

Exadata I/O rate management is specific to Oracle Exadata Database Machine environments and is not a standard CDB plan resource available in non-Exadata Oracle Database installations.

FLocal file system I/O

Local file system I/O is not a resource category managed or prioritized by Oracle Database Resource Manager in CDB or PDB resource plans.

Concept tested: Oracle CDB Resource Manager plan resource directives

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-resources-with-oracle-database-resource-manager.html

Topics

#Database Resource Manager#CDB PDB#resource allocation#resource plans

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice