user process memory
- From: "Ujang Jaenudin" <ujang.jaenudin@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 26 Nov 2007 18:12:50 +0700
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
