Re: ORA-04030

From: Gulamabbas Sikiladha <gsiki_at_hotmail.com>
Date: Sat, 2 Dec 2000 19:13:29 -0500
Message-ID: <90c6b0$nhp$1@localhost.localdomain>

I recently got the same error on Open VMS System with another ora error 7629.
I had to call Oracle Support and finally after a number of trials we found the problem, it was associated with the Page Flo Quota on OpenVMS, increasing this parameter on the O/S and I ran the SQL successfully. U may want to check some of the parameters on the O/S. Hope this helps

Peter Kroiss wrote in message <3a278857_at_alijku02.edvz.uni-linz.ac.at>...
>I've a problem that I often get the following error:
>ORACLE-Error ORA-04030: out of process memory when trying to allocate
>336396 bytes (callheap,kllcqas:kllsltba)
>StackTrace: java.sql.SQLException: ORA-04030: out of process memory when
>trying to allocate 336396 bytes (callheap,kllcqas:kllsltba)
>
>I join 2 tables using the primary-key, the average size of touples returned
>is 25000. The only speciality on the statement is
>that I try to order the result randomly using:
> ORDER BY (MOD ((ATTRIBUTE1 + 11243)*13, 19999) + (1-ATTRFLAG)*12499)
>
>Is it posible that Oracle has a memory problem with the MOD-function?
>
>Can anybody help me?
>
>Peter
>
>
Received on Sat Dec 02 2000 - 18:13:29 CST