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

VIEW: SYS.CDB_CDB_RSRC_PLAN_DIRECTIVES

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

all the CDB resource plan directives in all containers

[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
CON_ID NUMBER

container id
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
,      CON_ID
FROM SYS.CDB_CDB_RSRC_PLAN_DIRECTIVES;

Dependencies

[top of page]

SYS.CDB_CDB_RSRC_PLAN_DIRECTIVES does not reference any database object

SYS.CDB_CDB_RSRC_PLAN_DIRECTIVES is referenced by following:

SchemaPUBLIC
SynonymCDB_CDB_RSRC_PLAN_DIRECTIVES