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 |
---|---|---|---|
|
|
|
Unique snapshot ID |
|
|
|
Database ID for the snapshot |
|
|
|
Instance number for the snapshot |
|
|
|
Name of the resource |
|
|
Number of (resources, locks, or processes) currently being used |
|
|
|
Maximum consumption of the resource since the last instance start up |
|
|
|
Initial allocation. This will be equal to the value specified for the resource in the initialization parameter file ( |
|
|
|
Unlimited for resources and locks. This can be greater than the initial allocation value ( |
|
|
|
The database ID of the PDB for the sampled session |
|
|
|
The ID of the container that
|