Already a member?
Sign in
| Version | User | Scope of changes |
|---|---|---|
| Jan 24 2008, 2:29 PM EST (current) | olapdba | |
| Jan 24 2008, 2:27 PM EST | olapdba | 101 words added |
Changes
Key: Additions Deletions
set lines 110 pages 5000
col userid format a10
col client_type for a16
col atat hea 'AVERAGE|TXN TIME'
col ttat hea 'TOTAL|TXN TIME'
col atct hea 'AVERAGE|CPU TIME'
col ttct hea 'TOTAL|CPU TIME'
select userid, session_id sid, serial#, 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 v$aw_session_info, v$session where userid=username and session_id=sid ;
.....................................................AVERAGE......TOTAL....AVERAGE......TOTAL
USERID............SID....SERIAL# CLIENT_TYPE........TXN TIME...TXN.TIME...CPU.TIME...CPU.TIME
---------- ---------- ---------- ---------------- ---------- ---------- ---------- ----------
DM................144..........9.CLIENT_TYPE_OLAP...... .014...... .014...... .014..........0
col userid format a10
col client_type for a16
col atat hea 'AVERAGE|TXN TIME'
col ttat hea 'TOTAL|TXN TIME'
col atct hea 'AVERAGE|CPU TIME'
col ttct hea 'TOTAL|CPU TIME'
select userid, session_id sid, serial#, 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 v$aw_session_info, v$session where userid=username and session_id=sid ;
.....................................................AVERAGE......TOTAL....AVERAGE......TOTAL
USERID............SID....SERIAL# CLIENT_TYPE........TXN TIME...TXN.TIME...CPU.TIME...CPU.TIME
---------- ---------- ---------- ---------------- ---------- ---------- ---------- ----------
DM................144..........9.CLIENT_TYPE_OLAP...... .014...... .014...... .014..........0
