8.193 V$RSRC_PLAN_HISTORY
V$RSRC_PLAN_HISTORY
displays 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 |
---|---|---|
|
|
A sequential counter that uniquely describes a row. When the instance is restarted, this value is reset to zero. |
|
|
Resource plan ID; NULL if the Resource Manager was disabled |
|
|
Resource plan name; NULL if the Resource Manager was disabled |
|
|
Time that the resource plan was enabled |
|
|
Time that the resource plan was disabled; NULL if the row contains the current resource plan information |
|
|
Indicates whether the plan was enabled by a Job Scheduler window ( |
|
|
Job Scheduler window that triggered the resource plan event; NULL if a user triggered the resource plan event |
|
|
Indicates whether automated plan switches were allowed after this resource plan event ( See Also: the |
|
|
Indicates whether the resource plan has parameters that specify a policy for how the Resource Manager should schedule sessions to manage CPU usage ( |
|
|
Indicates whether instance caging is enabled ( |
|
|
State of parallel statement queuing:
For an Oracle RAC database, only the instance running as master Database Resource Manager (DBRM) shows the correct state of parallel statement queuing. All other instances default to the value |
|
|
The ID of the container to which the data pertains. Possible values include:
|