ORA-04030

From: Peter Kroiss <pk_at_faw.uni-linz.ac.at>
Date: Fri, 1 Dec 2000 12:20:48 +0100
Message-ID: <3a278857@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 Fri Dec 01 2000 - 05:20:48 CST