How to check SGA target advice in Oracle

V$SGA_TARGET_ADVICE predicts DB time for different SGA target sizes. Look for the point where increasing SGA no longer meaningfully reduces DB time — that is the sweet spot.

SELECT * FROM v$sga_target_advice ORDER BY sga_size;