Materialized view refresh monitor

column "MVIEW BEING REFRESHED" format a30
column INSERTS format 9999999
column UPDATES format 9999999
column DELETES format 9999999
select x.sid_knst,
    x.serial_knst,
    CURRMVOWNER_KNSTMVR || '.' || CURRMVNAME_KNSTMVR "MVIEW BEING REFRESHED",
    decode(REFTYPE_KNSTMVR, 1, 'FAST', 2, 'COMPLETE', 'UNKNOWN') REFTYPE,
    decode(GROUPSTATE_KNSTMVR,
       1,
       'SETUP',
       2,
       'INSTANTIATE',
       3,
       'WRAPUP',
       'UNKNOWN') STATE,
    TOTAL_INSERTS_KNSTMVR INSERTS,
    TOTAL_UPDATES_KNSTMVR UPDATES,
    TOTAL_DELETES_KNSTMVR DELETES
 from X$KNSTMVR x
 where type_knst = 6
  and exists (select 1
     from v$session s
     where s.sid = x.sid_knst
      and s.serial# = x.serial_knst);

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26104736/viewspace-710419/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26104736/viewspace-710419/