1Z0-083 practice question 2 of 35

Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?

Full set: 286 questions
Answer options
A: If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB. Correct answer
B: In a PDB plan, subplans may be used with up to eight consumer groups.
C: If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.
D: If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
E: If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan. Correct answer
Correct Answer:
A. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.; E. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.
Explanation

In a multitenant architecture, Oracle Resource Manager operates hierarchically. The CDB resource plan allocates resources among PDBs. Within each PDB, a PDB resource plan can further allocate that PDB's resources among its internal consumer groups. If a PDB does not have an active plan, its allocated resources are distributed equally among all its active sessions. If a PDB plan is active, the resources for its consumer groups are a fraction of the PDB's total allocation, which is determined by the CDB plan. This ensures a two-level resource management structure.

Why Incorrect

B. A PDB plan can contain up to 32 consumer groups, not just eight. The eight-level limit for plan directives is a different concept.
C. A PDB plan manages resources for consumer groups within that specific PDB, not across all PDBs in the CDB.
D. The PDB's share is explicitly defined in the CDB resource plan directives; it is not dynamically calculated based on the PDB plan's status.

References

1. Oracle Database Administrator’s Guide, 19c. Chapter 29, "Managing Resource Allocation with Oracle Database Resource Manager". Section: "Managing Resources in a Multitenant Environment". It states, "If a PDB does not have an active resource plan, then resources are allocated equally among the sessions in the PDB."

2. Oracle Database Administrator’s Guide, 19c. Chapter 29, "Managing Resource Allocation with Oracle Database Resource Manager". Section: "About CDB Resource Plans and PDB Resource Plans". It explains that a PDB's resource allocation is determined by the CDB plan, and a PDB plan subdivides that allocation.

Scroll to Top