oracle库查看当前库占用多少内存空间

查询脚本如下，直接执行即可：

select 'SGA' as name
      ,round(sum(value) / 1024 / 1024, 2) || 'M' as "SIZE(M)"
from   v$sga
union
select 'PGA' as name, round(value / 1024 / 1024, 2) || 'M' as "SIZE(M)"
from   v$pgastat
where  name = 'total PGA allocated'

版权声明：本文为hkl_Forever原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。