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