/* Information about SGA resize operations are currently in progress. An operation can be a grow or a shrink of a dynamic SGA component.*/ select * from V$SGA_CURRENT_RESIZE_OPS; /* Information about the last 100 completed SGA resize operations. This does not include any operations currently in progress. */ select * from V$SGA_RESIZE_OPS ; /* Information about the dynamic components in SGA. This view summarizes information based on all completed SGA operations since startup. */ select * from V$SGA_DYNAMIC_COMPONENTS ; /*Information about the amount of SGA memory available for future dynamic SGA resize operations.*/ select current_size/1024/1024/1024 from V$SGA_DYNAMIC_FREE_MEMORY SELECT size_for_estimate, buffers_for_estimate, estd_physical_read_factor, estd_physical_reads FROM V$DB_CACHE_ADVICE WHERE name = 'DEFAULT' AND advice_status = 'ON' AND block_size = (SELECT value FROM V$PARAMETER WHERE name = 'db_block_size') SELECT * FROM V$PARAMETER WHERE name = 'db_cache_advice'