select username,user
,session_num
,tablespace
, contents
,segtype
,extents
,blocks*8 kbytes
from v$tempseg_usage
order by username
/