How To See Active Mviews

This is other way, more interesnting in my opinion, to see active mviews, I use it from many years, I don’t remember where I get it, maybe ML/MOS, of course, you can see it as usual by query the dba_jobs_running

 

REM
REM Active Mviews Refresh
REM 

SELECT 
   S.OBJ#,
   O.OBJ#,
   S.CONTAINEROBJ#,
   LASTREFRESHDATE,
   PFLAGS,
   XPFLAGS,
   O.NAME,
   O.OWNER#, 
   BITAND(S.MFLAGS, 8) 
FROM 
   OBJ$ O, 
   SUM$ S
WHERE 
   O.OBJ# = S.OBJ# AND 
   O.TYPE# = 42 AND 
   BITAND(S.MFLAGS, 8) = 8;                                                         
/

HTH – Antonio NAVARRO

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s