could some one tell the concept Oracle uses in sorting ...using temporary segments, iit is said that the same temporary segment will be used by all users for sorting ,, will each user get a different extent for his sort and is the temporary segment allocated tablespace wise or it is one for an instance ??

could also the SORT_AREA_SIZE and SORT_AREA_RETAINED SIZE be clarified ???

regards,
sharmila