USER 

VARCHAR2(30) 

User who requested temporary space 

SESSION_ADDR 

RAW(4) 

Address of shared SQL cursor 

SESSION_NUM  

NUMBER 

Serial number of session 

SQLADDR 

RAW(4) 

Address of SQL statement 

SQLHASH  

NUMBER 

Hash value of SQL statement 

TABLESPACE 

VARCHAR2(31) 

Tablespace in which space is allocated 

CONTENTS 

VARCHAR2(9) 

Indicates whether tablespace is TEMPORARY/PERMANENT 

SEGFILE# 

NUMBER 

File number of initial extent 

SEGBLK# 

NUMBER 

Block number of the initial extent 

EXTENTS 

NUMBER 

Extents allocated to the sort 

BLOCKS 

NUMBER 

Extents in blocks allocated to the sort  

SEGRFNO#  

NUMBER 

Relative file number of initial extent