V$RSRC_PLAN_HISTORY provides a history of when a resource plan was enabled, disabled, or modified on the instance. Up to 15 of the most recent entries are shown. Once the database is opened, this view shows at least one row. The row with the most recent START_TIME and with END_TIME equal to NULL gives information about the current resource plan.
| Column | Datatype | Description |
|---|---|---|
SEQUENCE# |
NUMBER |
A sequential counter that uniquely describes a row. When the instance is restarted, this value is reset to zero. |
ID |
NUMBER |
The resource plan object id, V$RSRC_PLAN.ID. NULL if the resource manager was disabled. |
NAME |
VARCHAR2(30) |
The resource plan name. NULL if the resource manager was disabled. |
START_TIME |
DATE |
The time that the resource plan was enabled |
END_TIME |
DATE |
The time that the resource plan was disabled. NULL if the row contains the current resource plan information. |
ENABLED_BY_SCHEDULER |
VARCHAR2(5) |
TRUE if a Job Scheduler window enabled the plan. FALSE otherwise. |
WINDOW_NAME |
VARCHAR2(30) |
The Job Scheduler window that triggered the resource plan event. If a user triggered the resource plan event, this field is NULL. |
ALLOWED_AUTOMATED_SWITCHES |
VARCHAR2(5) |
TRUE if automated plan switches were allowed after this resource plan event. FALSE if automated plan switches were disabled after this resource plan event. For more details, see the SWITCH_PLAN procedure. |