select
  x$ktsso.inst_id,                         -- INST_ID NUMBER
  username,                                -- USERNAME VARCHAR2(30)
  username,                                -- USER VARCHAR2(30)
  ktssoses,                                -- SESSION_ADDR RAW(8)
  ktssosno,                                -- SESSION_NUM NUMBER
  prev_sql_addr,                           -- SQLADDR RAW(8)
  prev_hash_value,                         -- SQLHASH NUMBER
  prev_sql_id,                             -- SQL_ID VARCHAR2(13)
  ktssotsn,                                -- TABLESPACE VARCHAR2(31)
  decode(                                  -- CONTENTS VARCHAR2(9)
    ktssocnt, 0, 'PERMANENT', 1, 'TEMPORARY'),
  decode(                                  -- SEGTYPE VARCHAR2(9)
    ktssosegt, 1, 'SORT', 2, 'HASH', 3, 'DATA', 4, 'INDEX', 5, 'LOB_DATA', 6, 'LOB_INDEX' , 'UNDEFINED'),
  ktssofno,                                -- SEGFILE# NUMBER
  ktssobno,                                -- SEGBLK# NUMBER
  ktssoexts,                               -- EXTENTS NUMBER
  ktssoblks,                               -- BLOCKS NUMBER
  ktssorfno                                -- SEGRFNO# NUMBER
from
  x$ktsso,
  v$session
where
  ktssoses = v$session.saddr and ktssosno = v$session.serial#