Re: PGA size in V$SESSTAT compared to RES size on HP_UX

Hi, John,

Since I don't have access to HPUX, I take Solaris as an example. In Solaris there's a command /usr/proc/bin/pmap -x [PID] that lists each segment of the process. One segment is listed as [ heap ]. That's what you need to compare. Its size is slightly larger than "session pga memory" statistic (in my case, 648k vs. 536964 bytes). Maybe the difference is some operating system overhead.

Yong Huang

"John van Eck" <JvanEck_at_ssc.dordrecht.nl> wrote in message news:<1027331110.988657_at_newsreader2.wirehub.nl>...
> Hello,
>
> In the dynamic view V$SESSTAT there is een statistic which is called
> 'session pga memory' , you also have got session pga memory (max). This is
> supposed to be the size of physical memory used by the PGA of the session.
> Via glance on HP-UX I watched the same process, if I calculate the sum of
> the private memory areas RSS size of this process (so I already excluded all
> shared memory area size) I come to a number about three times as high as the
> value from the view V$SESSTAT.
> Is there anybody that can explain this difference?
Received on Mon Jul 22 2002 - 16:40:07 CDT