DISTRIB TRAN xxxxx.xxxx.xx.x.xx , delete pending committed tran

DISTRIB TRAN CPROD.09cbaeca.13.4.461945
  is local tran 7.25.134449 (hex=07.19.20d31))
  delete pending committed tran, scn=307675863991 (hex=47.a2e91bb7)
DISTRIB TRAN CPROD.09cbaeca.20.20.6177045
  is local tran 8.15.146564 (hex=08.0f.23c84))
  delete pending committed tran, scn=307675865119 (hex=47.a2e9201f)
DISTRIB TRAN CPROD.09cbaeca.19.13.2916021
  is local tran 9.31.190895 (hex=09.1f.2e9af))
  delete pending committed tran, scn=307675865718 (hex=47.a2e92276)
DISTRIB TRAN CPROD.09cbaeca.20.33.6174616
  is local tran 10.9.497125 (hex=0a.09.795e5))
  delete pending committed tran, scn=307675862108 (hex=47.a2e9145c)
DISTRIB TRAN CPROD.09cbaeca.49.25.371661
  is local tran 22.25.226416 (hex=16.19.37470))
  delete pending committed tran, scn=307675879989 (hex=47.a2e95a35)
DISTRIB TRAN CPROD.09cbaeca.54.13.460852
  is local tran 23.18.70792 (hex=17.12.11488))
  delete pending committed tran, scn=307675875418 (hex=47.a2e9485a)
DISTRIB TRAN CPROD.09cbaeca.19.12.2915929
  is local tran 24.29.85519 (hex=18.1d.14e0f))
  delete pending committed tran, scn=307675882833 (hex=47.a2e96551)
DISTRIB TRAN CPROD.09cbaeca.15.10.559530
  is local tran 25.9.74623 (hex=19.09.1237f))
  delete pending committed tran, scn=307675885380 (hex=47.a2e96f44)
DISTRIB TRAN CPROD.09cbaeca.52.1.803522
  is local tran 27.26.152091 (hex=1b.1a.2521b))
  delete pending committed tran, scn=307675886006 (hex=47.a2e971b6)
DISTRIB TRAN CPROD.09cbaeca.52.29.803709
  is local tran 28.6.70899 (hex=1c.06.114f3))
  delete pending committed tran, scn=307675888481 (hex=47.a2e97b61)
DISTRIB TRAN CPROD.09cbaeca.19.14.2914844
  is local tran 29.17.69468 (hex=1d.11.10f5c))
  delete pending committed tran, scn=307675889171 (hex=47.a2e97e13)

该信息主要出现在RAC系统中,意思是:
当前系统存在分布式作业,正在等待其它节点完成作业。是一种延时提示。

如果未出现ORA-告警,其实是可以不理会的。

可以使用如下方式关闭oracle RAC分布式特性
alter system set _CLUSTERWIDE_GLOBAL_TRANSACTIONS=FALSE scope=spfile;

然后restart database ,生效。

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值