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


Latest page update: made by olapdba , Jan 24 2008, 2:29 PM EST (about this update About This Update olapdba Edited by olapdba


view changes

- complete history)
Keyword tags: None
More Info: links to this page

There are no threads for this page. 

Anonymous  (Get credit for your thread)


Wiki pages
Top Contributors