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

VIEW: SYS.CDB_HIST_RSRC_PLAN

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

Historical resource plan statistics in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
SNAP_ID NUMBER
Yes
DBID NUMBER
Yes
INSTANCE_NUMBER NUMBER
Yes
SEQUENCE# NUMBER
Yes
START_TIME DATE
Yes
END_TIME DATE

PLAN_ID NUMBER
Yes
PLAN_NAME VARCHAR2 (128) Yes
CPU_MANAGED VARCHAR2 (4) Yes
PARALLEL_EXECUTION_MANAGED VARCHAR2 (4)
CON_DBID NUMBER

CON_ID NUMBER

container id
Query Text

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


SELECT SNAP_ID
,      DBID
,      INSTANCE_NUMBER
,      SEQUENCE#
,      START_TIME
,      END_TIME
,      PLAN_ID
,      PLAN_NAME
,      CPU_MANAGED
,      PARALLEL_EXECUTION_MANAGED
,      CON_DBID
,      CON_ID
FROM SYS.CDB_HIST_RSRC_PLAN;

Dependencies

[top of page]

SYS.CDB_HIST_RSRC_PLAN does not reference any database object

SYS.CDB_HIST_RSRC_PLAN is referenced by following:

SchemaPUBLIC
SynonymCDB_HIST_RSRC_PLAN