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. |