I think I have answered my own question.

According to this query I am right.

1 select bytes, count(bytes)
2 from dba_extents
3 where tablespace_name = 'TEMP'
4* group by bytes
SQL> /

BYTES COUNT(BYTES)
---------- ------------
786432 55


Database has been up for 2 days, more than 1 session has requested a sort. Maybe I should email him with this.


[Edited by Sureshy on 06-26-2002 at 06:26 AM]