Search notes:
Oracle: V$SGA_DYNAMIC_COMPONENTS
v$sga_dynamic_components
: information about sga resize operations since startup.
This view can also be used to find out the granule size of
SGA components.
select
component
from
v$sga_dynamic_components
order by
lower(component);
--
-- ASM Buffer Cache
-- DEFAULT 16K buffer cache
-- DEFAULT 2K buffer cache
-- DEFAULT 32K buffer cache
-- DEFAULT 4K buffer cache
-- DEFAULT 8K buffer cache
-- DEFAULT buffer cache
-- java pool
-- KEEP buffer cache
-- large pool
-- RECYCLE buffer cache
-- Shared IO Pool
-- shared pool
-- streams pool
select
component,
to_char(current_size / 1024/1024, '999,999') size_mb
from
v$sga_dynamic_components
order by
current_size desc;