Hi,

Sanjay is perfectly correct. The same temporary tablespace could have been allocated to multiple users.

If you want to find out whether your query uses temporary tablespace(sorts on disk) then enable autotrace in your
session and then issue the same statement.

Thanks.
Vijay.