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 |
COMPONENT |
VARCHAR2(64) |
NOT NULL |
Component name |
CURRENT_SIZE |
NUMBER |
|
Current size of the component |
MIN_SIZE |
NUMBER |
|
Minimum size of the component since instance startup |
MAX_SIZE |
NUMBER |
|
Maximum size of the component since instance startup |
USER_SPECIFIED_SIZE |
NUMBER |
|
Value of the user parameter for the component |
OPER_COUNT |
NUMBER |
|
Number of operations since instance startup |
LAST_OPER_TYPE |
VARCHAR2(13) |
|
Last completed operation for the component:
-
STATIC
-
INITIALIZING
-
DISABLED
-
GROW
-
SHRINK
-
SHRINK_CANCEL
|
LAST_OPER_MODE |
VARCHAR2(9) |
|
Mode of the last completed operation:
-
MANUAL
-
DEFERRED
-
IMMEDIATE
|
LAST_OPER_TIME |
DATE |
|
Start time of the last completed operation |
GRANULE_SIZE |
NUMBER |
|
Granularity of the GROW or SHRINK operation |
