In V$MEMORY_RESIZE_OPS / V$SGA_RESIZE_OPS we can have three different automatic re-size operations:
o DEFERRED
o MANUAL
o IMMEDIATE
- Deferred requests are low priority requests coming from advisory components like v$shared_pool_advice, v$db_cache_advice etc.
- Immediate requests represent re-size operations due to memory crunch problems, e.g. in situations of imminent ORA-04031 errors.
o DEFERRED
o MANUAL
o IMMEDIATE
- Deferred requests are low priority requests coming from advisory components like v$shared_pool_advice, v$db_cache_advice etc.
- Immediate requests represent re-size operations due to memory crunch problems, e.g. in situations of imminent ORA-04031 errors.
- Manual requests represent re-size operations due to 'alter system' commands.
参考文档What Type of SGA Re-Size Operations Occur When DB_CACHE_ADVICE=OFF? (文档 ID 1434975.1)