客户系统alert log中出现大量的分布式延时信息:
Wed Jun 03 20:05:44 2015
DISTRIB TRAN HAIERMDM.f905907b.355.1.7544
is local tran 355.1.7544 (hex=163.01.1d78)
insert pending committed tran, scn=13510368365236 (hex=c49.a0b50ab4)
Wed Jun 03 20:05:44 2015
DISTRIB TRAN HAIERMDM.f905907b.355.1.7544
is local tran 355.1.7544 (hex=163.01.1d78))
delete pending committed tran, scn=13510368365236 (hex=c49.a0b50ab4)
Wed Jun 03 20:06:01 2015
DISTRIB TRAN HAIERMDM.f905907b.367.26.7664
is local tran 367.26.7664 (hex=16f.1a.1df0)
insert pending committed tran, scn=13510369096808 (hex=c49.a0c03468)
DISTRIB TRAN HAIERMDM.f905907b.288.26.1945
is local tran 288.26.1945 (hex=120.1a.799)
insert pending committed tran, scn=13510369097002 (hex=c49.a0c0352a)
Wed Jun 03 20:06:01 2015
DISTRIB TRAN HAIERMDM.f905907b.367.26.7664
is local tran 367.26.7664 (hex=16f.1a.1df0))
delete pending committed tran, scn=13510369096808 (hex=c49.a0c03468)
DISTRIB TRAN HAIERMDM.f905907b.288.26.1945
is local tran 288.26.1945 (hex=120.1a.799))
delete pending committed tran, scn=13510369097002 (hex=c49.a0c0352a)
该信息主要出现在RAC系统中,意思是:
当前系统存在分布式作业,正在等待其它节点完成作业。是一种延时提示。
如果未出现ORA-告警,其实是可以不理会的。
可以使用如下方式关闭oracle RAC分布式特性
alter system set _CLUSTERWIDE_GLOBAL_TRANSACTIONS=FALSE scope=spfile;
然后restart database ,生效。
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/26474945/viewspace-1686516/
,如需转载,请注明出处,否则将追究法律责任。