Reports2017-11-18T12:27:27+00:00

DBA SGA Memory Allocation

Description
Categories: DBA, Enginatics
Current SGA memory usage, showing the split between buffer cache and shared pool.

select
gsi.inst_id,
gsi.name,
decode(gsi.name,'Maximum SGA Size',null,gsi.bytes)/sum(decode(gsi.name,'Maximum SGA Size',null,gsi.bytes)) over (partition by gsi.inst_id)*100 percentage,
gsi.bytes/1000000000 ram
from
gv$sgainfo gsi
order by
gsi.inst_id,
gsi.bytes desc


By continuing to use the site, you agree to the use of cookies. Accept