Shows Memory Target Advice
--
-- Memory Target Advice
--
 
SET PAUSE ON
SET PAUSE 'Press Return to Continue'
SET PAGESIZE 60
SET LINESIZE 300
 
SELECT *
FROM   v$memory_target_advice
ORDER BY memory_size
/

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License