GV$AW_SESSION_INFO

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)     -- AVERAGE_TRANSACTION_TIME NUMBER
  /1000000,
trncputime/1000000,      -- TRANSACTION_CPU_TIME NUMBER
tottrncputime/1000000,   -- TOTAL_TRANSACTION_CPU_TIME NUMBER
(tottrncputime/tottrns)  -- AVERAGE_TRANSACTION_CPU_TIME NUMBER
  /1000000 
from
x$xssinfo
home |  up  |  mailbox