Originally posted by SANJAY_G
As Pando said, your SORT_AREA_SIZE is too big. If there are 5 sessions doing sorts concurrently, 1 GB of memory will be taken up by this 5 sessions.
Yep. Change the following parameters to lower values.

SORT_AREA_SIZE
SORT_AREA_RETAINED_SIZE

This should help you I guess.