← Performance
Oracle · Performance

How to check MEMORY_TARGET advice in Oracle

Show V$MEMORY_TARGET_ADVICE predictions for sizing the Oracle Automatic Memory Management MEMORY_TARGET parameter.

Tested on11g12c18c19c21c23ai26ai

V$MEMORY_TARGET_ADVICE predicts DB time for different MEMORY_TARGET values under Automatic Memory Management. Use it to justify a larger MEMORY_TARGET or to confirm the current one is right-sized.

SELECT *
FROM   v$memory_target_advice
ORDER BY memory_size;
performancememorymemory_targetammv$memory_target_advice