PGA

HP-UX 11.00 running Oracle 9.2.0 using a mix of shared and dedicated servers. A dev box btw.

Have a few things about PGA that I'm trying to clear up.

The number of dedicated servers are small, the work done via them fine (fine as fine goes ;-), so that's not a problem and PGA aggregated target works good.

Shared servers otoh - big problem. Sort and hash sizes are default. Still I get shared server PGAs that grow to over 700MB (before dropping in mem again).

This is likely due in part to exprimentation with bulk collects into PL/SQL table objects - see just how much can be bulk collected in a single shot.

Is there a way to limit just how big the PGA grows in such a case?

The other funny is the discrepancie between HP-UX's Glance and Oracle's V$PROCESS PGA memory columns.

Glance currently shows me that shared server zero is using 400MB of memory. V$PROCESS tells me that used, allocated and max PGA for the server are respectively 727KB, 1189KB and 571197KB.

The 1189KB (plus the freeable PGA of 0KB according to V$PROCESS) does not add up to the 400MB that Glance tells me. Nor what ps -lfp tells me (i.e. what the core image size of the process is).

Comments?

--
Billy