Granules

Granules:

SGA memory is allocated in units of contiguous memory chunks called granules.
The size of the granule depend on the estimated total SGA and the version of the database.

select bytes from v$sgainfo where name = 'Granule Size';

Memory Advisories:

Buffer Cache Advice:

V$DB_CACHE_ADVICE

Shared Pool Advice:

V$SHARED_POOL_ADVICE

Java Pool Advice:

V$JAVA_POOL_ADVICE

Stream Pool Advice:

V$STREAM_POOL_ADVICE

SGA Sizing Parameter

1. Auto-Tuned Parameters:

SHARED_POOL_SIZE

DB_CACHE_SIZE

LARGE_POOL_SIZE

STREAM_POOL_SIZE

2. Manual Dynamic Parameters:

DB_KEEP_CACHE_SIZE

DB_RECYCLE_CACHE_SIZE

DB_nK_CACHE_SIZE

RESULT_CACHE_MAX_SIZE

SGA_TARGET 

3. Manual Static Parameters:

LOG_BUFFER

SGA_MAX_SIZE