Re: Program Global Area

From: Kristiaan J. Kolk <akolk_at_ix.netcom.com>
Date: 1997/09/02
Message-ID: <340CB578.72D24777@ix.netcom.com>#1/1

Actually your sort is allocate from the PGA if you run dedicated servers, so reducing sort_area_size is an option. Also disabling the hash_join option is a way to save memory.

K.J.K.

Brian Gastineau wrote:

> What parameters control the size of the Program Global Area?
>
> I'm running into the process memory limits on the HP Unix server. I've
> requested that this limit be raised through a kernel rebuild, but am also
> interested in other solutions that anyone may have. I am hoping that by
> lowering limits on the Program Global Area, I can force Oracle to use less
> primary memory and more hard disk storage, much like the SGA does with
> large sorts.
>
> Thanks,
> Brian
Received on Tue Sep 02 1997 - 00:00:00 CDT