A Wetpaint Site

Sign in to Wetpaint

Sign in or

Monitor Session Information for Multidimensional Datatype Access (11.1.0)

Page Versions

Key: additions deletions

Showing 7 pages

	Date/Time	Made By	Edit Note	Type	Scope
	Jul 9 2009, 1:27 PM EDT	olapdba		edit	1 word added 1 word deleted
Change: TTL TXN .. AVG TXN .. TTL TXNUSERID ... 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 View changes from previous version. (Word count: 125)
	Jul 9 2009, 1:26 PM EDT	olapdba		edit	27 words added 12 words deleted
Change: userid,userid, a.inst_id,a.inst_id, session_id\|\|','\|\|serial# sdsr, client_type, client_type, round(average_transaction_time,3) atat,atatround(total_transaction_time,3), ttat,round(total_transaction_time,3) ttatround(average_transaction_time,3), atct,round(average_transaction_time,3) atct, round(total_transaction_cpu_time,3) ttctfrom gv$aw_session_info a,a, gv$session bwhere userid=username and session_id=sid and a.inst_id=b.inst_idorder by userid, a.inst_id;...................................................... AVG TXN .. TTL TXN View changes from previous version. (Word count: 125)
	Jul 9 2009, 1:20 PM EDT	olapdba		edit	14 words added 5 words deleted
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)
	Jul 9 2009, 1:16 PM EDT	olapdba		edit	51 words added 46 words deleted
Change: AVG TXN TTL TXN AVG TXN TTL TXNUSERID............SID....SERIAL# INST_ID SID,SERIAL# CLIENT_TYPE........TXN TIME TIME CPU TIME...TXN.TIME...CPU.TIME...CPU.TIME CPU TIME---------- ---------- ---------------------- ---------------- ---------- ---------- ---------- ----------DM................144..........9.CLIENT_TYPE_OLAP...... .014......OLAPTRAIN View changes from previous version. (Word count: 125)
	Jan 24 2008, 2:29 PM EST	olapdba		edit
Change: There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 94)
	Jan 24 2008, 2:27 PM EST	olapdba		edit	101 words added
Change: 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) ttctfrom v$aw_session_info, v$session where userid=username and session_id=sid ; .....................................................AVERAGE......TOTAL....AVERAGE......TOTALUSERID............SID....SERIAL# CLIENT_TYPE........TXN TIME...TXN.TIME...CPU.TIME...CPU.TIME---------- ---------- ---------- View changes from previous version. (Word count: 94)
	Jan 24 2008, 2:22 PM EST	olapdba		create	No content added or deleted.
Change: Created by olapdba Jan 24 2008, 2:22 PM EST for: no reason given

JavaScript must be enabled in order for you to contribute to this site.
To start contributing, enable JavaScript by changing your browser options, then try again.

Home