Which two resources might be prioritized between competing pluggable databases (PDBs)
when creating a multitenant container database (COB) plan using Oracle Database
Resource Manager?
A.
maximum undo per consumer group
B.
maximum idle time for a session in a PDB
C.
parallel server limit
D.
CPU
E.
maximum number of sessions for a PDB
C and D are correct
Creating a CDB Resource Plan: A Scenario
This section uses a scenario to illustrate each of the steps involved in creating a CDB resource plan. The scenario assumes that you want to create a CDB resource plan for a CDB named newcdb. The plan includes a directive for each PDB. In this scenario, you also update the default directive and the autotask directive.
The directives are defined using various procedures in the DBMS_RESOURCE_MANAGER package. The attributes of each directive are defined using parameters in these procedures. Table 44-5 describes the types of directives in the plan.
Table 44-5 Attributes for PDB Directives in a CDB Resource Plan
Directive Attribute – Description
shares Resource allocation share for CPU and parallel execution server
resources. See “Shares for Allocating Resources to PDBs”.
utilization_limit Resource utilization limit for CPU. See “Utilization Limits for
PDBs”.
parallel_server_limit Maximum percentage of parallel execution servers that a PDB can use.
When the parallel_server_limit directive is specified for a PDB, the
limit is the value of the PARALLEL_SERVERS_TARGET initialization
parameter multiplied by the value of the parallel_server_limit
parameter in the CREATE_CDB_PLAN_DIRECTIVE procedure. See
“Utilization Limits for PDBs”.
Thanks Vonpire!
CD
CD
CD