Saturday, March 23, 2013

Check total Size for Ram/memory For Oracle

Check total size of Ram/Memory For Each Database :

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(value)
    from v$sysstat
   where name = 'session pga memory'
  )
   group by rollup(nm)

The Orginial Post from Tom Kyte.


Thank you
Osama Mustafa

2 comments:

  1. The topic is remarkable. I actually never think I could have an excellent read by this time until I find out this website. I am thankful for the information. Thank you for being so kind enough to have shared your information with us.Oracle SQL

    ReplyDelete
    Replies
    1. Thank you :) you can follow me on Twitter or follow my blog :)

      Delete