ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 关于高级复制引起log file sync等待的探讨

关于高级复制引起log file sync等待的探讨

原创 Linux操作系统 作者:microsoft_fly 时间:2010-10-14 09:19:17 0 删除 编辑
我们这里的配置:一台主站点,3台物化视图站点,在主站点v$session_wait经常有log file sync等待,抓到相关session的SQL,语句基本上是跟高级复制有关的SQL
select decode(bitand(s.flags,1),0,0,1), NVL(max(s.scn), 0)  from sumpartlog$ s  where s.bo# = :1 and nvl(s.scn,0) <= :2  group by decode(bitand(s.flags,1),0,0,1)
update sys.mlog$ set oldest = :1, oldest_pk = :2, oldest_oid = :3,  oldest_new = :4, youngest = :5  where master = :6 and mowner = :7
update sys.mlog$ set oldest = :1, oldest_pk = :2, oldest_oid = :3,  oldest_new = :4, youngest = :5  where master = :6 and mowner = :7
select decode(bitand(s.flags,1),0,0,1), NVL(max(s.scn), 0)  from sumpartlog$ s  where s.bo# = :1 and nvl(s.scn,0) <= :2  group by decode(bitand(s.flags,1),0,0,1)
select decode(bitand(s.flags,1),0,0,1), NVL(max(s.scn), 0)  from sumpartlog$ s  where s.bo# = :1 and nvl(s.scn,0) <= :2  group by decode(bitand(s.flags,1),0,0,1)
update sys.mlog$ set oldest = :1, oldest_pk = :2, oldest_oid = :3,  oldest_new = :4, youngest = :5  where master = :6 and mowner = :7
update sys.mlog$ set oldest = :1, oldest_pk = :2, oldest_oid = :3,  oldest_new = :4, youngest = :5  where master = :6 and mowner = :7
update sys.mlog$ set oldest = :1, oldest_pk = :2, oldest_oid = :3,  oldest_new = :4, youngest = :5  where master = :6 and mowner = :7
select decode(bitand(s.flags,1),0,0,1), NVL(max(s.scn), 0)  from sumpartlog$ s  where s.bo# = :1 and nvl(s.scn,0) <= :2  group by decode(bitand(s.flags,1),0,0,1)
update sys.mlog$ set oldest = :1, oldest_pk = :2, oldest_oid = :3,  oldest_new = :4, youngest = :5  where master = :6 and mowner = :7
环境:linux as 4    oracle 9.2.0.4
从这里看出,高级复制会产生log file sync等待,应该说数据同步高级复制算是一种成熟的方法,难道ORACLE对这个技术没有考虑过会有log file sync等待吗,就像单次提交和批量提交一样,我想ORACLE公司应该能考虑到这个问题!

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

上一篇: BMB结构问题探讨
请登录后发表评论 登录
全部评论

注册时间:2008-11-06

  • 博文量
    41
  • 访问量
    99342