GV$AW_SESSION_INFO definition in Oracle 10g / 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
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