Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

V$RSRC_PLAN_HISTORY

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.