SGA Granules
In 9i, the SGA architecture was reengineered with a concepts called granules which are uniformely sized memory units that can be allocated, freed or relocated between memory areas such as buffer cache and shared pool depending on the workload.
The size of the granules are dependent on OS,
Oracle version and size of the SGA (MOS ID #947152.1).
It can be determined with
select bytes/1024/1024 gran_sz_mb from v$sgainfo where name = 'Granule Size';
Queries
select
component,
current_size/power(1024,2) size_mb,
last_oper_type,
last_oper_time,
granule_size
from
v$memory_dynamic_components
order by
component;