GV$AW_SESSION_INFO definition in Oracle Database 10.2 / www.oracledba.ru
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