SQL> select name,total,round(total-free,2) used, round(free,2) free,round((total-free)/total*100,2) pctused from (select 'SGA' name,(select sum(value/1024/1024) from v$sga) total,(select sum(bytes/1024/1024) from v$sgastat where name='free memory')free from dual)unionselect name,total,round(used,2)used,round(total-used,2)free,round(used/total*100,2)pctused from (select 'PGA' name,(select value/1024/1024 total from v$pgastat where name='aggregate PGA target parameter')total,(select value/1024/1024 used from v$pgastat where name='total PGA allocated')used from dual); 2 3 4 5 6 7 NAM TOTAL USED FREE PCTUSED--- ---------- ---------- ---------- ----------PGA 377 327.12 49.88 86.77SGA 1135.99883 1067.11 68.89 93.94 查看内存大小
|