select "SESSION_ID","CLIENT_TYPE","SESSION_STATE","SESSION_HANDLE","USERID","TOTAL_TRANSACTION","TRANSACTION_TIME","TOTAL_TRANSACTION_TIME","AVERAGE_TRANSACTION_TIME","TRANSACTION_CPU_TIME","TOTAL_TRANSACTION_CPU_TIME","AVERAGE_TRANSACTION_CPU_TIME","CON_ID" from v$aw_session_info
SELECT "SESSION_ID"
, "CLIENT_TYPE"
, "SESSION_STATE"
, "SESSION_HANDLE"
, "USERID"
, "TOTAL_TRANSACTION"
, "TRANSACTION_TIME"
, "TOTAL_TRANSACTION_TIME"
, "AVERAGE_TRANSACTION_TIME"
, "TRANSACTION_CPU_TIME"
, "TOTAL_TRANSACTION_CPU_TIME"
, "AVERAGE_TRANSACTION_CPU_TIME"
, "CON_ID"
FROM V$AW_SESSION_INFO
|
|
|