GV$AW_SESSION_INFO

select
inst_id,                 -- INST_ID NUMBER
client,                  -- CLIENT_TYPE VARCHAR2(64)
state,                   -- SESSION_STATE VARCHAR2(64)
sesshandle,              -- SESSION_HANDLE NUMBER
userid,                  -- USERID VARCHAR2(64)
cdmlcmd,                 -- CURR_DML_COMMAND VARCHAR2(64)
pdmlcmd,                 -- PREV_DML_COMMAND VARCHAR2(64)
tottrns,                 -- TOTAL_TRANSACTION NUMBER
tottrntime,              -- TOTAL_TRANSACTION_TIME NUMBER
avgtrntime,              -- AVERAGE_TRANSACTION_TIME NUMBER
trncputime,              -- TRANSACTION_CPU_TIME NUMBER
tottrncputime,           -- TOTAL_TRANSACTION_CPU_TIME NUMBER
avgtrncputime            -- AVERAGE_TRANSACTION_CPU_TIME NUMBER
from
x$xssinfo
home |  up  |  mailbox