Yes as far as i think when sorting exceeds SORT_ARE_SIZE
and user has been asigned temporary tablespace then only one segment is created in the temp tablespace and it will do sorting for all users untill the instance shutdown..The MAX_EXTENTS are unlimited (to the size of temp tablespace).
Please anyone if i am wrong.




Reply With Quote