Surveillance information about the temporary table space being used:
Select SE.USERNAME
, SE.SID
, Su.extents
, su.blocks * to_number (rtrim (p.Value)) As Space
, TableSpace
SEGTYPE
SQL_Text
From v $ sort_usage su
, V $ Parameter P
, V $ session se
, V $ SQL S
Where p.name = 'db_block_size'
And Su.Session_addr = se.saddr
And s.hash_value = su.sqlhash and s.address = su.sqladdr
Order by se.username, SE.SID
/
