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 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_MINFoot 1

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

MEMORY_LIMITFootref 1

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

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.

Footnote 1

This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).