Welcome! This is a website that everyone can build together. It's easy!

Monitor OLAP option Multidimensional Datatype TEMP & LOB Reads, Cache Writes and Rows Processed

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


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. 

Anonymous  (Get credit for your thread)


Site pages
Top Contributors