Doc

    Name:    sgastat.sql

    This script lists key SGA memory usage

#

ttitle 'SGA Memory Usage'

SELECT * 
FROM v$sgastat
WHERE name IN (‘free memory’, ‘db_block_buffers’, ‘log_buffer’
               ‘dictionary cache’, ‘sql area’, ‘library cache’);