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

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

Post a Comment

Popular posts from this blog

Connection refused; No available router to destination On Weblogic Node Manager Log

How to change SGA in Oracle Rac

SGA_MAX_SIZE & SGA_TARGET / MEMORY_TARGET & MEMORY_MAX_TARGET