You should "select table_name from dict where table_name like '%TEMP%' order by 1;"
to find tables/views that will answer your question.
Try this one...
Code:
SQL> desc V$TEMPSEG_USAGE
Name Null? Type
----------------------------------------------------------------------- -------- ------------------------------------------------
USERNAME VARCHAR2(30)
USER VARCHAR2(30)
SESSION_ADDR RAW(8)
SESSION_NUM NUMBER
SQLADDR RAW(8)
SQLHASH NUMBER
SQL_ID VARCHAR2(13)
TABLESPACE VARCHAR2(31)
CONTENTS VARCHAR2(9)
SEGTYPE VARCHAR2(9)
SEGFILE# NUMBER
SEGBLK# NUMBER
EXTENTS NUMBER
BLOCKS NUMBER
SEGRFNO# NUMBER