[Home] [Help] [Dependency Information]
Object Name: | DBA_CDB_RSRC_PLAN_DIRECTIVES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
all the CDB resource plan directives
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 |
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;
|
|
|