what does deffered mean in oper_mode column of v$sga_resize_ops;?
what does deffered mean in oper_mode column of v$sga_resize_ops?
What does INITIALIZING mean in oper_type column of v$sga_resize_ops?
SQL> select COMPONENT,OPER_TYPE,OPER_MODE ,PARAMETER from v$sga_resize_ops;
COMPONENT OPER_TYPE OPER_MODE PARAMETER
------------------------------ ------------- --------- ------------------------------
shared pool STATIC shared_pool_size
large pool STATIC large_pool_size
DEFAULT buffer cache INITIALIZING db_cache_size
RECYCLE buffer cache INITIALIZING db_recycle_cache_size
ASM Buffer Cache STATIC db_cache_size
java pool STATIC java_pool_size
streams pool STATIC streams_pool_size
DEFAULT buffer cache STATIC db_cache_size