Hi Again,

ERROR at line 14:
ORA-04030: out of process memory when trying to allocate 8192 bytes (sort subheap,sort key)

Some of the documents suggest to increase the sort area and some suggest to decrease the sort area. I am not sure which is correct. I see a very little 0.01% of disk sorts compared to the memory sorts.

I already have 100M sort area, which seemed to be high but looking at disk sorts, does it mean even this sort area size is small?

Badrinath