Re: ORA-04030

From: peter <wu0020_at_home.com>
Date: Fri, 17 Dec 1999 16:31:28 GMT
Message-ID: <Azt64.6040$ZT5.3340510@news1.rdc1.on.wave.home.com>

Hi,

I have this problem on HP unix once. the reason is oracle process trying to allocate too much memory, exceed Unix limit for a single process. You can change Kernel setting of Aix to allow more memory for each process, or change your SQL statement to use less memory , or reduce Sort_area_size if you are using large Sort_area_size setting.

miwallace wrote in message <38598B1F.2EF49F2D_at_ibm.net>...
>Getting Message ORA-04030, running oracle 8.0.5 on IBM RS/6000, and I
>can't find much info on this message and solution. Any help appreciated.
>
>Mike Wallace
>
Received on Fri Dec 17 1999 - 10:31:28 CST