How to see how much memory is allocated for an instance?

Question

Oracle

What are the ways to find out how much memory is allocated for an instance in Oracle Database 11g r2? Needed to transfer to a new server.

Answer 1

one)

select name,display_value 
  from v$parameter 
 where name like 'mem%target' 
    or name like 'pga%' 
    or name like 'sga%';

2)

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$sesstat a, v$statname b
    where b.name = 'session pga memory'
    and a.statistic# = b.statistic#  )
  group by rollup(nm)  ;