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). |
