DBA SGA Memory Allocation
Description
Categories: Enginatics
Repository: Github
Repository: Github
Current SGA memory usage in gigabytes, showing the split between buffer cache and shared pool
Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS
Contact us to schedule a demo or if you need help with the installation
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 |