DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.DBA_CDB_RSRC_PLAN_DIRECTIVES

Object Details
Object Name: DBA_CDB_RSRC_PLAN_DIRECTIVES
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

all the CDB resource plan directives

[View Source]

Columns
Name Datatype Length Mandatory Comments
PLAN VARCHAR2 (128)
Name of the CDB plan to which this directive belongs
PLUGGABLE_DATABASE VARCHAR2 (128)
Name of the pluggable database referred to
PROFILE VARCHAR2 (128)
Name of database profile referred to
DIRECTIVE_TYPE VARCHAR2 (30)
Type of CDB directive: PDB, PROFILE, AUTOTASK, or DEFAULT_DIRECTIVE
SHARES NUMBER

Resource allocation for this pluggable database, 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

minimum memory available, expressed in percentage
MEMORY_LIMIT NUMBER

maximum memory allowed, expressed in percentage
COMMENTS VARCHAR2 (2000)
Text comment on the plan directive
STATUS VARCHAR2 (128)
PENDING if it is part of the pending area, NULL otherwise
MANDATORY VARCHAR2 (3)
Whether the plan directive is mandatory
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PLAN
,      PLUGGABLE_DATABASE
,      PROFILE
,      DIRECTIVE_TYPE
,      SHARES
,      UTILIZATION_LIMIT
,      PARALLEL_SERVER_LIMIT
,      MEMORY_MIN
,      MEMORY_LIMIT
,      COMMENTS
,      STATUS
,      MANDATORY
FROM SYS.DBA_CDB_RSRC_PLAN_DIRECTIVES;

Dependencies

[top of page]

SYS.DBA_CDB_RSRC_PLAN_DIRECTIVES references the following:

SchemaSYS
TableCDB_RESOURCE_PLAN_DIRECTIVE$
SYS.DBA_CDB_RSRC_PLAN_DIRECTIVES is referenced by following:

SchemaPUBLIC
SynonymDBA_CDB_RSRC_PLAN_DIRECTIVES
SchemaSYS
Package BodyDBMS_WLM - show dependent code
Package BodyPRVTEMX_DBHOME - show dependent code