HI all,

I was wondering if anyone could help me...i am continually getting then following error:

ORA-04030: out of process memory when trying to allocate 262144 bytes (cursor
work he,kllcqas:kllsltba)

The SQL that is running is very large, and quite complex. When I take the WHERE clause out, it seems to work fine (this is what I would expect)


My INITODSD.ORA file has the following paramaters:

open_cursors = 100
db_block_buffers = 64000
db_writer_processes = 1
shared_pool_size = 157286400
large_pool_size = 31457280


1) Is there anything that I can change to eliminate this error?
2) What does this error REALLY mean?

Thanks in advance,

Keith