← 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