Which two statements are true concerning the Resource Manager plans for individual pluggable
databases (PDB plans) in a multitenant container database (CDB)?
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.
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.
Explanation:
A: Setting a PDB resource plan is optional. If not specified, all sessions within the
PDB are treated equally.
*
In a non-CDB database, workloads within a database are managed with resource plans.
In a PDB, workloads are also managed with resource plans, also called PDB resource plans.
The functionality is similar except for the following differences:
/ Non-CDB DatabaseMulti-level resource plans
Up to 32 consumer groups
Subplans
/ PDB Database
Single-level resource plans only
Up to 8 consumer groups
(not B) No subplans
IncorrectNot C
D is incorrect
A,E
AE
A and E
AE
AE
AE
B E
Resources in pdb, You can have only a maximun of eight consumer groups.
Sorry i was wrong , in a pdb eight consumer groups but not subplans available in pdb. Not multilevel resource plan in a PDB
https://docs.oracle.com/database/121/ADMIN/cdb_dbrm.htm#ADMIN13774
D C
A E , after reading more stuff, sorry for the previous noise
https://docs.oracle.com/database/121/ADMIN/cdb_dbrm.htm#ADMIN13774
When you do not explicitly define directives for a PDB, the PDB uses the default directive
CREATE_PENDING_AREA
DBMS_RESOURCE_MANAGER.CREATE_CDB_PLAN_DIRECTIVE
DBMS_RESOURCE_MANAGER.DELETE_CDB_PLAN_DIRECTIVE
DBMS_RESOURCE_MANAGER.UPDATE_CDB_PLAN_DIRECTIVE
Directive in CDB Plan in PDB
Inside the PDB to create a PLAN
In SQL*Plus, ensure that the current container is a PDB.
Create a pending area using the CREATE_PENDING_AREA procedure.
Create, modify, or delete consumer groups using the CREATE_CONSUMER_GROUP procedure.
Map sessions to consumer groups using the SET_CONSUMER_GROUP_MAPPING procedure.
Create the PDB resource plan using the CREATE_PLAN procedure.
Create PDB resource plan directives using the CREATE_PLAN_DIRECTIVE procedure.
Validate the pending area using the VALIDATE_PENDING_AREA procedure.
Submit the pending area using the SUBMIT_PENDING_AREA procedure.
A,E correct