Change: TXN| TIME'TXN|TIME'col ttat hea 'TTL
TXN| TIME'TXN|TIME'col atct hea 'AVG TXN|CPU TIME'col ttct hea 'TTL TXN|CPU TIME'col sdsr for a12 hea 'SID,SERIAL#'
select userid, a.inst_id, session_id||','||serial# sdsr, client_type,
round(average_transaction_time,3) atat,
round(total_transaction_time,3) ttat,
round(average_transaction_time,3) atct,
round(total_transaction_cpu_time,3) ttctfrom gv$aw_session_info a, gv$session bwhere userid=username
View changes from previous version.
(Word count: 125)