DBA_HIST_RSRC_PLAN displays historical information about resource plans. This view contains snapshots of V$RSRC_PLAN_HISTORY.
Unique snapshot ID
Database ID for the snapshot
Instance number for the snapshot
A sequential counter that uniquely describes a row. When the instance is restarted, this value is reset to zero.
Time that the resource plan was enabled
Time that the resource plan was disabled; NULL if the row contains the current resource plan information
Resource plan ID; NULL if the Resource Manager was disabled
Resource plan name; NULL if the Resource Manager was disabled
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)
State of parallel statement queuing:
OFF - Parallel statement queuing is disabled
STARTUP - Parallel statement queuing is enabled. This is a temporary state that can occur when an Oracle RAC database is undergoing configuration changes
FIFO - Parallel statement queuing is enabled. All parallel statements are managed in a single Oracle RAC FIFO queue
FULL - Parallel statement queuing is enabled. All parallel statements are managed in per-consumer group queues according to the current resource plan. This state is used when a resource plan that contains resource allocation directives (MGMT_P*) is enabled.
The database ID of the PDB for the sampled session
The ID of the container that CON_DBID identifies. Possible values include:
0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.
1: This value is used for rows containing data that pertain to only the root
n: Where n is the applicable container ID for the rows containing data