DBA_CDB_RSRC_PLAN

4.142 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 Database Administrator’s Guide.

Column	Datatype	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 the buffer cache and shared pool cache (which includes the library cache and row cache) that is guaranteed to the PDB This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).
`MEMORY_LIMIT`	`NUMBER`	The maximum percentage of the buffer cache, shared pool cache (which includes the library cache and row cache), and PGA that the PDB can use This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).
`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.