Check the Memory used by Oracle

Check the Memory usage used by Oracle from Operating System

Check the SGA_TARGET and PGA_TARGET size :

SQL> select sum(value)/1024/1024/1024 from v$parameter where name in ('sga_target','pga_aggregate_target');


If MEMORY_TARGET is used then check the memory usage form that :

select (value)/1024/1024/1024 from v$parameter where name in ('MEMORY_TARGET');

Check from the real stats view:

   select decode( grouping(nm), 1, 'total', nm ) nm, round(sum(val/1024/1024)) mb
   select 'sga' nm, sum(value) val
   from v$sga
   union all
   select 'pga', sum(a.value)
   from v$sesstat a, v$statname b
   where = 'session pga memory'
   and a.statistic# = b.statistic#
  group by rollup(nm);

NM            MB
----- ----------
pga          173
sga         1024
total       1197

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

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