Monitor OLAP option Multidimensional Datatype TEMP & LOB Reads, Cache Writes and Rows ProcessedThis is a featured page

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.. LOB_READS.. CACHE_WRS..ROWS_PROCD
------------------------ ----------- ----------- ----------- -----------
SCOTT (138,24)................64,263........ 200.. 2,188,942.......... 0


olapdba
olapdba
Latest page update: made by olapdba , Apr 17 2008, 12:07 PM EDT (about this update About This Update olapdba Edited by olapdba

17 words added
6 words deleted

view changes

- complete history)
Keyword tags: None
More Info: links to this page
There are no threads for this page.  Be the first to start a new thread.