This view describes sort usage.

Column Datatype Description
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


Close Window