Version User Scope of changes
Apr 17 2008, 12:07 PM EDT (current) olapdba 17 words added, 6 words deleted
Apr 17 2008, 12:06 PM EDT olapdba 69 words added

Changes

Key:  Additions   Deletions
set lines 110

col usn format a24 heading "User (SID,SERIAL#)"
col temp_reads format 99,999,999
col lob_reads format 99,999,999
col cache_wrs format 99,999,999
col rows_procd format 99,999,999

select username||' ('||sid||','||serial#||')' usn, sum(temp_space_reads) temp_reads,
sum(lob_reads) lob_reads, sum(cache_writes) cache_wrs, sum(rows_processed) rows_procd
from v$aw_olap vo, v$session, v$aw_calc vc, v$aw_longops vl
where sid=vo.session_id and vo.session_id=vc.session_id group by username, sid, serial#;

User (SID,SERIAL#)........TEMP_READS..(SID,SERIAL#)........TEMP_READS.. LOB_READS..LOB_READS.. CACHE_WRS..ROWS_PROCDCACHE_WRS..ROWS_PROCD
------------------------ ----------- ----------- ----------- -----------
SCOTT (138,24)................64,263........(138,24)................64,263........ 200..200.. 2,188,942..........2,188,942.......... 0