Sign in or 
Share this
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
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 |
Latest page update: made by olapdba
, Apr 17 2008, 12:07 PM EDT
(about this update
About This Update
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.
