select
  USERNAME,                                -- USERNAME VARCHAR2(30)
  "USER",                                  -- USER VARCHAR2(30)
  SESSION_ADDR,                            -- SESSION_ADDR RAW(8)
  SESSION_NUM,                             -- SESSION_NUM NUMBER
  SQLADDR,                                 -- SQLADDR RAW(8)
  SQLHASH,                                 -- SQLHASH NUMBER
  SQL_ID,                                  -- SQL_ID VARCHAR2(13)
  TABLESPACE,                              -- TABLESPACE VARCHAR2(31)
  CONTENTS,                                -- CONTENTS VARCHAR2(9)
  SEGTYPE,                                 -- SEGTYPE VARCHAR2(9)
  SEGFILE#,                                -- SEGFILE# NUMBER
  SEGBLK#,                                 -- SEGBLK# NUMBER
  EXTENTS,                                 -- EXTENTS NUMBER
  BLOCKS,                                  -- BLOCKS NUMBER
  SEGRFNO#                                 -- SEGRFNO# NUMBER
from
  GV$SORT_USAGE
where
  inst_id = USERENV('Instance')