Which two statements are true about 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 Database
Multi-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
A and E?
A
Not B < — You can create hierarchical plans with any number of subplans.
Not C < — Before you enable the Resource Manager, you must specify how user sessions are assigned to resource consumer groups. You do this by creating mapping rules that enable the Resource Manager to automatically assign each session to a consumer group upon session startup, based upon session attributes.
Not D < — A CDB resource plan determines the amount of resources allocated to each PDB. A PDB resource plan determines how the resources allocated to a specific PDB are allocated to consumer groups within that PDB.
E
Sorry to correct the answers,
I found B is not correct:
B < — A PDB resource plan can have a maximum of eight consumer groups.
But B is talking about a subbplan and not a resource plan..
I think A is correct because:
What Solutions Does Resource Manager Provide for a CDB?
When resource allocation decisions for a CDB are left to the operating system, you may encounter the following problems with workload management:
Inappropriate allocation of resources among PDBs
The operating system distributes resources equally among all active processes and cannot prioritize one task over another. <— A
https://docs.oracle.com/database/121/ADMIN/cdb_dbrm.htm#ADMIN13788
Thanks feedback!
B wrong. A PDB resource plan cannot have subplans.
https://docs.oracle.com/database/121/ADMIN/cdb_dbrm.htm#ADMIN13774
Not C too. We enable Resource Plan in CDB not in Pluggable database.
In the root for a CDB, RESOURCE_MANAGER_PLAN specifies the CDB resource plan. A CDB resource plan allocates resources among PDBs.
https://docs.oracle.com/cloud/latest/db121/REFRN/refrn10189.htm#REFRN10189
AE
AE
Answer BC and E are correct.
I had posted above answer for last question.
I correct myself here.
Correct answers are A and E.
AE
https://docs.oracle.com/cd/E49329_01/server.121/b71301/cdb_dbrm.htm#CACDJFGE
AE
A PDB resource plan cannot have subplans. – B incorrect
If a PDB-level plan is not enabled, Resource Manager will allocate equal resources to all sessions for that PDB. –A correct , D incorrect
PDB-level plan prioritizes only the workload within a particular PDB and not for other PDBs in a CDB – C incorrect
AE