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