Memory Allocation Notes
/* 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
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'