RE: Dedicated process memory - NT

Sum v$sga + pga curr + uga_curr = 517.8Mb

Using Task Manager on the server shows oracle.exe memory usage at 549980 = 537.1 Mb and VM usage = 566936 = 553.6 Mb

I can't explain the difference between the Task Manager output and the script output - maybe memory structures not in v$sga but I wouldn't have thought they added to 20 Mb.

Our v$session count was 26 which was the number of pga rows returned by the script (& yes it includes the background processes).

• @pga_usage.sql
• 24-Dec-2001 , Bruce Reardon
• 6-Mar-2002 , B Reardon - added uga_current values.

COLUMN pga_curr format 99,999,999.9
COLUMN pga_max format 99,999,999.9
COLUMN uga_curr format 99,999,999.9
COLUMN uga_max format 99,999,999.9

BREAK ON report
COMPUTE SUM LABEL "Total mem" OF pga_curr , pga_max , uga_curr , uga_max ON report

select s.sid , s.username , s.program ,

   pga_curr.value AS pga_curr, pga_max.value AS pga_max ,    uga_curr.value AS uga_curr , uga_max.value AS uga_max FROM
   v$session s ,
( select st.sid , st.value/1024/1024 AS value
from v$sesstat st , v$statname sn
where st.statistic#=sn.statistic#

   and sn.name = 'session pga memory'
) pga_curr ,
( select st.sid , st.value/1024/1024 AS value
from v$sesstat st , v$statname sn
where st.statistic#=sn.statistic#

   and sn.name = 'session pga memory max' ) pga_max ,
( select st.sid , name , st.value/1024/1024 AS value
from v$sesstat st , v$statname sn
where st.statistic#=sn.statistic#

   and sn.name = 'session uga memory'
) uga_curr ,
( select st.sid , name , st.value/1024/1024 AS value
from v$sesstat st , v$statname sn
where st.statistic#=sn.statistic#

   and sn.name = 'session uga memory max' ) uga_max

WHERE pga_curr.sid = s.sid
  AND pga_max.sid  = s.sid
  AND uga_curr.sid  = s.sid
  AND uga_max.sid  = s.sid