user process memory

From: Ujang Jaenudin <ujang.jaenudin_at_gmail.com>
Date: Mon, 26 Nov 2007 18:12:50 +0700
Message-ID: <3edcb66e0711260312i439d7e02g5c07a4d069beb594@mail.gmail.com>

all,

I got confused with user memory on HP-UX.

when query by

select v$sesstat.sid, v$sysstat.name, v$sesstat.value from v$sysstat , v$sesstat
where v$sysstat.STATISTIC# = v$sesstat.STATISTIC# and v$sysstat.name in ('session pga memory','session uga memory') order by 1,2;

each session only takes up to 4MB.

but from GLANCE (UX monitor tool) it took 23MB.

what is the problem???

from OS perfective , it seems the machine has very high utilization.

--

regards
ujang
jakarta - indonesia
http://ujang-id.blogspot.com
--

http://www.freelists.org/webpage/oracle-l Received on Mon Nov 26 2007 - 05:12:50 CST