Oracle server is using more than 7 GB of ram.

  Hello,

 

I am facing one problem relating to physical memory utilization on database server.

My operating system is window server 2003 r2 standard x64 edition with service pack 2 and total physical ram on this server is 8 GB and oracle version is 10.2.0.4.

 

I have run below query on my database to find how much memory is used by oracle database.

SQL>  select nvl(d

  2  ,'Total Memory Usage....') "Mem Type"

  3   ,round(sum(b) / 1024 / 1024) "MB"

  4   from (select 'System Global Area:' d

  5   ,sum(bytes) b

  6   from v$sgastat

  7   union all

  8   select 'Program Global Area:' d

  9   ,value b

 10   from v$pgastat

 11   where name = 'total PGA allocated') s