DBA_HIST_RSRC_PLAN displays historical information about resource plans. This view contains snapshots of V$RSRC_PLAN_HISTORY.
| Column | Datatype | NULL | Description |
|---|---|---|---|
SNAP_ID |
NUMBER |
NOT NULL |
Unique snapshot ID |
DBID |
NUMBER |
NOT NULL |
Database ID for the snapshot |
INSTANCE_NUMBER |
NUMBER |
NOT NULL |
Instance number for the snapshot |
SEQUENCE# |
NUMBER |
NOT NULL |
A sequential counter that uniquely describes a row. When the instance is restarted, this value is reset to zero. |
START_TIME |
DATE |
NOT NULL |
Time that the resource plan was enabled |
END_TIME |
DATE |
NOT NULL |
Time that the resource plan was disabled; NULL if the row contains the current resource plan information |
PLAN_ID |
NUMBER |
NOT NULL |
Resource plan ID; NULL if the Resource Manager was disabled |
PLAN_NAME |
VARCHAR2(30) |
NOT NULL |
Resource plan name; NULL if the Resource Manager was disabled |
CPU_MANAGED |
VARCHAR2(4) |
NOT NULL |
Indicates whether the resource plan has parameters that specify a policy for how the Resource Manager should schedule sessions to manage CPU usage (ON) or whether Resource Manager is not managing CPU usage (OFF) |