Which two resources might be prioritized between competing pluggable databases (PDBs) when creating a multitenant container database…?

Which two resources might be prioritized between competing pluggable databases (PDBs)
when creating a multitenant container database (COB) plan using Oracle Database
Resource Manager?

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



Leave a Reply 5

Your email address will not be published. Required fields are marked *


Vonpire

Vonpire

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”.

Tri

Tri

Thanks Vonpire!