-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|