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'