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

Question

Options

• AIf no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated
• BIn a PDB plan, subplans may be used with up to eight consumer groups.
• CIf a PDB plan is enabled for a pluggable database, then resources are allocated to consumer
• DIf no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is
• EIf a PDB plan is enabled for a pluggable database, then resources are allocated to consumer

• A
  79% (31)
• B
  3% (1)
• C
  13% (5)
• D
  5% (2)

Explanation

Oracle Resource Manager: PDB Plans in a CDB

Option A is correct because when no PDB plan is enabled, Oracle treats all sessions within that PDB as belonging to a single default consumer group - all sessions compete equally for the PDB's allocated share of CDB resources, with no internal differentiation.

Option E is correct because when a PDB plan is enabled, Oracle Resource Manager allocates the PDB's CDB-granted resources internally among the consumer groups defined in that PDB plan, giving the DBA granular control over workloads within the PDB.

Why B is wrong: PDB plans do not support subplans - subplans are a feature of CDB-level plans only. This is a key restriction that distinguishes PDB plans from CDB plans.

Why C is wrong: It likely misrepresents how resources are allocated when a PDB plan is active - the PDB plan governs internal consumer group allocation, not the CDB plan directly.

Why D is wrong: The absence of a PDB plan does not alter how the CDB plan assigns shares to the PDB itself; the PDB still receives its CDB-level share - it just doesn't subdivide it internally.

Memory tip: Think of two separate tiers: the CDB plan slices the pie among PDBs (shares/utilization limits), and the PDB plan re-slices each PDB's slice among its consumer groups. No PDB plan = no re-slicing; subplans only belong at the CDB tier.

No community discussion yet for this question.