More than 1GB PGA under Oracle 9.2.0.5/Solaris 9

All,

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

We are running an application that bulk collects without a limit clause.
A rewrite is in progress, but will take several days.

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

The process grows continuously and at about 1GB it dies with

ORA-04030: out of process memory when trying to allocate 16408 bytes
(koh-kghu sessi,pl/sql cursor meta-data) 
ORA-06500: PL/SQL: storage error

We have for oracle:
> ulimit -a
time(seconds)          unlimited
file(blocks)           unlimited
data(kbytes)           unlimited
stack(kbytes)          16384
coredump(blocks)       unlimited
nofiles(descriptors)   256
vmemory(kbytes)        unlimited

Any suggestions?

Martin

P.S. It is my understanding that pga_aggregate_target does not play a
role here.
--
http://www.freelists.org/webpage/oracle-l

Other related posts: