Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> PGA and UGA contents?? Some help please
Hi guys
I have an OLTP application on HP-UX and Oracle 7.3.4.
Some of the user processes ( I am not sure whether I am politically correct,
since they might be the server process component of a dedicated server, user
session) keep growing their resident part in the memory until Unix starts
paging.
Could anyone help on this matter please.
My first problem is to find out what is kept in each user's PGA or UGA.
Could it be that some open cursors (I know they all go to Library cache) or
something similar.
These processes are not real live users but bunch of NT services like unix
daemons which execute the same statements from dome stored procedures day
in day out. They do not perform any long queries or massive sorts. All the
sessions enjoy a 2.5MB of Sort_Area_Size with 1.25MB of it as retained.
Thank you all in advance.
Reza
Received on Mon Nov 22 1999 - 06:03:30 CST