select
  SESSION_ID,                              -- SESSION_ID NUMBER
  CLIENT_TYPE,                             -- CLIENT_TYPE VARCHAR2(64)
  SESSION_STATE,                           -- SESSION_STATE VARCHAR2(64)
  SESSION_HANDLE,                          -- SESSION_HANDLE NUMBER
  USERID,                                  -- USERID VARCHAR2(64)
  TOTAL_TRANSACTION,                       -- TOTAL_TRANSACTION NUMBER
  TRANSACTION_TIME,                        -- TRANSACTION_TIME NUMBER
  TOTAL_TRANSACTION_TIME,                  -- TOTAL_TRANSACTION_TIME NUMBER
  AVERAGE_TRANSACTION_TIME,                -- AVERAGE_TRANSACTION_TIME NUMBER
  TRANSACTION_CPU_TIME,                    -- TRANSACTION_CPU_TIME NUMBER
  TOTAL_TRANSACTION_CPU_TIME,              -- TOTAL_TRANSACTION_CPU_TIME NUMBER
  AVERAGE_TRANSACTION_CPU_TIME             -- AVERAGE_TRANSACTION_CPU_TIME NUMBER
from
  gv$aw_session_info
where
  inst_id = USERENV('Instance')