See the following query. I find the OPER_MODE has the values:
MANUAL,
DEFERRED and
IMMEDIATE
SQL> desc V$MEMORY_RESIZE_OPS
Name Null? Type
----------------------------------------------------------------------------------------------------------------- --------
COMPONENT VARCHAR2(64)
OPER_TYPE VARCHAR2(13)
OPER_MODE VARCHAR2(9)
PARAMETER VARCHAR2(80)
INITIAL_SIZE NUMBER
TARGET_SIZE NUMBER
FINAL_SIZE NUMBER
STATUS VARCHAR2(9)
START_TIME DATE
END_TIME DATE
The OPER_MODE column have the following values:
* MANUAL
* DEFERRED
* IMMEDIATE
What do
MANUAL, DEFERRED and
IMMEDIATE mean here?