Re: PGA

On 12 Feb 2004 23:01:58 -0800, vslabs_at_onwe.co.za (Billy Verreynne) wrote:

>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?

Glance and ps include the shared memory segments, as has been, as far as I know, been posted here many times.
And this time I'm just too tired to reach for my leadpipe.

--
Sybrand Bakker, Senior Oracle DBA