5.212 DBA_CDB_RSRC_PLAN_DIRECTIVES

DBA_CDB_RSRC_PLAN_DIRECTIVES provides information about all the CDB resource plan directives.

Note:

ORA$DEFAULT_PDB_DIRECTIVE is the default directive for PDBs. For more information about ORA$DEFAULT_PDB_DIRECTIVE, see Oracle Multitenant Administrator's Guide.

Column	Datatype	NULL	Description
PLAN	VARCHAR2(128)		Name of the CDB resource plan to which this directive belongs
PLUGGABLE_DATABASE	VARCHAR2(128)		Name of the PDB referred to. NULL for profile directives
PROFILE	VARCHAR2(128)		For internal use only
DIRECTIVE_TYPE	VARCHAR2(30)		For internal use only
SHARES	NUMBER		Resource allocation, expressed in shares
UTILIZATION_LIMIT	NUMBER		Maximum resource utilization allowed, expressed in percentage
PARALLEL_SERVER_LIMIT	NUMBER		Maximum percentage of the parallel target used before queueing subsequent parallel queries
MEMORY_MIN	NUMBER		The percentage of Exadata Smart Flash Cache and Exadata PMEM cache that is guaranteed to the PDB This percentage is based on the total amount of space allocated to the CDB for Exadata Smart Flash Cache and Exadata PMEM cache. See Oracle Exadata System Software User's Guide for more information.
MEMORY_LIMIT	NUMBER		The maximum percentage of Exadata Smart Flash Cache and Exadata PMEM cache that the PDB can use This percentage is based on the total amount of space allocated to the CDB for Exadata Smart Flash Cache and Exadata PMEM cache. See Oracle Exadata System Software User's Guide for more information.
COMMENTS	VARCHAR2(2000)		Text comment on the resource plan directive
STATUS	VARCHAR2(128)		PENDING if it is part of the pending area, NULL otherwise
MANDATORY	VARCHAR2(3)		Whether the resource plan directive is mandatory. Mandatory plans cannot be deleted.

Note:

Oracle recommends that you do not use the parallel_server_limit directive in a CDB resource plan.