ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Materialized view refresh monitor

Materialized view refresh monitor

原创 Linux操作系统 作者:jesse_lui 时间:2011-11-08 11:39:16 0 删除 编辑
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/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2011-07-28

  • 博文量
    6
  • 访问量
    6735