-
ORA-04031 unable to allocate 8192 bytes
Dear All,
I got a porblem with Oracle 10g or 9i. When I try to join two big tables, the following error message came:
ORA-04031: Unable to allocate 8192 bytes of shared memory("large pool", "unknown object", "sort subheap", "sort key").
It looks like that the SGA is too small. But when I increase the SGA size (about 2G), this error is still there. Please advise me.
Thanks.
Xinhua
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
|