DBA_HIST_RESOURCE_LIMIT displays historical information about global resource use for some of the system resource. This view contains snapshots of V$RESOURCE_LIMIT.
If time is of interest, join this view with DBA_HIST_SNAPSHOT.END_INTERVAL_TIME.
| Column | Datatype | NULL | Description |
|---|---|---|---|
SNAP_ID |
NUMBER |
NOT NULL |
Unique snapshot ID |
DBID |
NUMBER |
NOT NULL |
Database ID for the snapshot |
INSTANCE_NUMBER |
NUMBER |
NOT NULL |
Instance number for the snapshot |
RESOURCE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the resource |
CURRENT_UTILIZATION |
NUMBER |
Number of (resources, locks, or processes) currently being used | |
MAX_UTILIZATION |
NUMBER |
Maximum consumption of the resource since the last instance start up | |
INITIAL_ALLOCATION |
VARCHAR2(10) |
Initial allocation. This will be equal to the value specified for the resource in the initialization parameter file (UNLIMITED for infinite allocation). |
|
LIMIT_VALUE |
VARCHAR2(10) |
Unlimited for resources and locks. This can be greater than the initial allocation value (UNLIMITED for infinite limit). |