select
  inst_id,                                 -- INST_ID NUMBER
  session_id,                              -- SESSION_ID NUMBER
  client,                                  -- CLIENT_TYPE VARCHAR2(64)
  state,                                   -- SESSION_STATE VARCHAR2(64)
  sesshandle,                              -- SESSION_HANDLE NUMBER
  userid,                                  -- USERID VARCHAR2(64)
  tottrns,                                 -- TOTAL_TRANSACTION NUMBER
  trntime/1000000,                         -- TRANSACTION_TIME NUMBER
  tottrntime/1000000,                      -- TOTAL_TRANSACTION_TIME NUMBER
  (tottrntime/tottrns)/1000000,            -- AVERAGE_TRANSACTION_TIME NUMBER
  trncputime/1000000,                      -- TRANSACTION_CPU_TIME NUMBER
  tottrncputime/1000000,                   -- TOTAL_TRANSACTION_CPU_TIME NUMBER
  (tottrncputime/tottrns)/1000000          -- AVERAGE_TRANSACTION_CPU_TIME NUMBER
from
  x$xssinfo