Who is occupying the space in temporary tablespaces.
Columns ___________________________ USERNAME USER SESSION_ADDR SESSION_NUM SQLADDR SQLHASH TABLESPACE CONTENTS SEGTYPE SEGFILE# SEGBLK# EXTENTS BLOCKS SEGRFNO#
Related:
V$GLOBAL_TRANSACTION V$SHARED_POOL_RESERVED V$SORT_SEGMENT V$STATNAME V$SYSSTAT V$SYSTEM_CURSOR_CACHE V$SYSTEM_EVENT V$TRANSACTION