A Wetpaint Site

Sign in to Wetpaint

Sign in or

Determine Wait Events for Sessions Attached to OLAP Multidimensional Datatypes

Page Versions
To-Dos

Key: additions deletions

Showing 6 pages

	Date/Time	Made By	Edit Note	Type	Scope
	Feb 19 2008, 12:43 PM EST	olapdba		edit
Change: There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 316)
	Feb 19 2008, 12:42 PM EST	olapdba		edit	271 words added
Change: ------------------- ------------------- ----------------------- --------- --- -------GLOBAL (272,58906)..SYS.AWXML (RO)................................ ON CPU..18...... 0GLOBAL (272,58906)..SYS.AWXML (RO)......latch free................WAITING.. 1..123692GLOBAL (272,58906)..SYS.AWXML (RO)......null event................WAITING.. 1...... 6GLOBAL (272,58906)..SYS.AWXML View changes from previous version. (Word count: 316)
	Feb 19 2008, 12:36 PM EST	olapdba		edit
Change: There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 101)
	Feb 19 2008, 12:36 PM EST	olapdba		edit	5 words added
Change: set lines 110 pages 500 col awuser format a25col awnm format a20col event format a25col session_state format a8 select username\|\|' ('\|\|sid\|\|','\|\|serial#\|\|')' as awuser, owner\|\|'.'\|\|aw_name\|\|' ('\|\|decode(attach_mode, 'READ WRITE', 'RW', 'READ ONLY', 'RO', 'MULTIWRITE', 'MW', 'EXCLUSIVE', 'XW', attach_mode)\|\|')' awnm, decode(session_state, 'WAITING', a.event, null) event, session_state, count(*) cnt, sum(time_waited) View changes from previous version. (Word count: 101)
	Feb 19 2008, 12:35 PM EST	olapdba		edit	77 words added
Change: 'RO', 'MULTIWRITE', 'MW', 'EXCLUSIVE', 'XW', attach_mode)\|\|')' awnm, decode(session_state, 'WAITING', a.event, null) event, session_state, count(*) cnt, sum(time_waited) waited from v$active_session_history a, v$session b, v$aw_olap c, dba_aws d where sid=a.session_id and sid=c.session_id and sample_time > sysdate-(1/24) and c.aw_number=d.aw_number group by username, sid, serial#, owner, aw_name, attach_mode, decode(session_state, 'WAITING', a.event, null), session_state; View changes from previous version. (Word count: 96)
	Feb 19 2008, 12:32 PM EST	olapdba		create	No content added or deleted.
Change: Created by olapdba Feb 19 2008, 12:32 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