Already a member?
Sign in
Welcome! Wikis are websites that everyone can build together. It's easy!
Monitor Session Information for Multidimensional Datatype Access (11.1.0)
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
Latest page update: made by olapdba
, Jan 24 2008, 2:29 PM EST
(about this update
About This Update
Edited by olapdba
view changes
- complete history)
Edited by olapdba
view changes
- complete history)
Keyword tags:
None
More Info: links to this page