前两天客户的DBA发函通知我们产品所用的oracle数据库(版本为10.2.0.4.0 - 64bit)日志切换频繁,不正常。拿到日志文件后我傻眼了,里面一分钟内全是这些内容,不知道怎么引起的,查了下资料,发现前辈有提出是QMN(队列监视)进程有关,将其参数设置为0。不知道各位大侠有没有遇到过?附日志内容:2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;事情催的很急,现在毫无头绪……
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;
2011-4-11 10:53
2011-4-11 10:53
2011-4-11 10:53 commit;
2011-4-11 10:53 set transaction read write;事情催的很急,现在毫无头绪……
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货