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 ,生效。