How to find memory used by Oracle

Below query may used to find the memory usage

sql">select decode( grouping(nm), 1, 'total', nm ) nm, round(sum(val/1024/1024)) mb

from

(

select 'sga' nm, sum(value) val

from v$sga

union all

select 'pga', sum(a.value)

from v$sesstat a, v$statname b

where b.name = 'session pga memory'

and a.statistic# = b.statistic#

)

group by rollup(nm);

 

READ ALSO
How to force users change password on first login Linux

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.