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
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'

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: