Version User Scope of changes
Jul 9 2009, 1:27 PM EDT (current) olapdba 1 word added, 1 word deleted
Jul 9 2009, 1:26 PM EDT olapdba 27 words added, 12 words deleted

Changes

Key:  Additions   Deletions
set lines 110 pages 5000

col userid format a10
col client_type for a16
col atat hea 'AVG TXN|TIME'
col ttat hea 'TTL 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) ttct
from gv$aw_session_info a, gv$session b
where userid=username and session_id=sid and a.inst_id=b.inst_id
order by userid, a.inst_id;

...................................................... AVG TXN .. TTL TXN .. AVG TXN .. TTL TXN
USERID ... INST_ID .. INST_ID SID,SERIAL#. CLIENT_TYPE .... ..... TIME ..... TIME . CPU TIME . CPU TIME
---------- ---------- ------------ ---------------- ---------- ---------- ---------- ----------
OLAPTRAIN. .........1 139,6 ...... CLIENT_TYPE_OLAP ... 18.612 ... 37.225 ... 18.612 ... 16.266