DBA SGA Memory Allocation
Description
Categories: Enginatics, Kcapps
Repository: Github
Repository: Github
Current SGA memory usage in gigabytes, showing the split between buffer cache and shared pool
Run
DBA SGA Memory Allocation and other Oracle EBS reports with Blitz Report™ on our demo environment
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 memory_size from gv$sgainfo gsi order by gsi.inst_id, gsi.bytes desc |
