RE: More than 1GB PGA under Oracle 9.2.0.5/Solaris 9

Buechi Martin Wrote:

> Is there a possibility that Oracle 9.2.0.5 under Solaris 9 can
allocate
> more than 1 GB PGA?

Yes.

> We are running an application that bulk collects without a limit
clause.

That's like driving a sportscar on a race track - without brakes. Not a question of whether it will crash, but a question of just how many bits and pieces will be left over after the crash.

> A rewrite is in progress, but will take several days.

In my experiences, it takes less than a few minutes to correct a BULK COLLECT loop that does not use a LIMIT clause. Of course, it depends on how may BULK COLLECTs there are to fix. But several days? That sounds like a developer that does not know what he/she needs to do to fix the code.

> In the meanwhile we are looking for a way to increase the memory
max.

Doubt that it will work as PGA memory is nothing but the data segment of dedicated or shared server process that runs that PL/SQL code. The max size of the data segment (DS) is a function of the o/s - the limit imposed by the kernel (if any) on a DS and whether there is free memory available to service that process image malloc requests. Seems like you are running into the latter. Malloc fails. And there is very little that can be done about it, but to use less memory.

--
Billy

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This e-mail and its contents are subject to the Telkom SA Limited
e-mail legal notice available at
http://www.telkom.co.za/TelkomEMailLegalNotice.PDF
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--
http://www.freelists.org/webpage/oracle-l