Thu Sep 15 00:28:58 2011
MMNL absent for 1203 secs; Foregrounds taking over
Thu Sep 15 00:46:36 2011
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=96
System State dumped to trace file /oracle/admin/sptdi/udump/sptdi2_ora_619084.trc
Thu Sep 15 00:49:04 2011
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=68
System State dumped to trace file /oracle/admin/sptdi/udump/sptdi2_ora_532814.tr
c
Thu Sep 15 00:54:50 2011
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=101
System State dumped to trace file /oracle/admin/sptdi/udump/sptdi2_ora_550404.tr
c
Thu Sep 15 00:55:00 2011
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=104
Thu Sep 15 00:55:30 2011
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=102
System State dumped to trace file /oracle/admin/sptdi/udump/sptdi2_ora_451900.tr
c
Thu Sep 15 00:58:15 2011
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=85
System State dumped to trace file /oracle/admin/sptdi/udump/sptdi2_ora_651598.tr
c
Thu Sep 15 01:15:18 2011
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=23
System State dumped to trace file /oracle/admin/sptdi/bdump/sptdi2_reco_70420.tr
c
Thu Sep 15 01:37:23 2011
MMNL absent for 5247 secs; Foregrounds taking over
System State dumped to trace file /oracle/admin/sptdi/udump/sptdi2_ora_451900.tr
c
Thu Sep 15 00:58:15 2011
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=85
System State dumped to trace file /oracle/admin/sptdi/udump/sptdi2_ora_651598.tr
c
Thu Sep 15 01:15:18 2011
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=23
System State dumped to trace file /oracle/admin/sptdi/bdump/sptdi2_reco_70420.tr
c
Thu Sep 15 01:37:23 2011
MMNL absent for 5247 secs; Foregrounds taking over
Thu Sep 15 01:37:24 2011
WARNING: inbound connection timed out (ORA-3136)
Thu Sep 15 01:37:24 2011
WARNING: inbound connection timed out (ORA-3136)
Thu Sep 15 01:37:24 2011
WARNING: inbound connection timed out (ORA-3136)
Thu Sep 15 01:37:24 2011
WARNING: inbound connection timed out (ORA-3136)
Thu Sep 15 01:37:24 2011
WARNING: inbound connection timed out (ORA-3136)
Thu Sep 15 01:37:24 2011
WARNING: inbound connection timed out (ORA-3136)如果有必林,再上传trc文件。
谢谢
MMNL absent for 1203 secs; Foregrounds taking over
Thu Sep 15 00:46:36 2011
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=96
System State dumped to trace file /oracle/admin/sptdi/udump/sptdi2_ora_619084.trc
Thu Sep 15 00:49:04 2011
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=68
System State dumped to trace file /oracle/admin/sptdi/udump/sptdi2_ora_532814.tr
c
Thu Sep 15 00:54:50 2011
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=101
System State dumped to trace file /oracle/admin/sptdi/udump/sptdi2_ora_550404.tr
c
Thu Sep 15 00:55:00 2011
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=104
Thu Sep 15 00:55:30 2011
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=102
System State dumped to trace file /oracle/admin/sptdi/udump/sptdi2_ora_451900.tr
c
Thu Sep 15 00:58:15 2011
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=85
System State dumped to trace file /oracle/admin/sptdi/udump/sptdi2_ora_651598.tr
c
Thu Sep 15 01:15:18 2011
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=23
System State dumped to trace file /oracle/admin/sptdi/bdump/sptdi2_reco_70420.tr
c
Thu Sep 15 01:37:23 2011
MMNL absent for 5247 secs; Foregrounds taking over
System State dumped to trace file /oracle/admin/sptdi/udump/sptdi2_ora_451900.tr
c
Thu Sep 15 00:58:15 2011
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=85
System State dumped to trace file /oracle/admin/sptdi/udump/sptdi2_ora_651598.tr
c
Thu Sep 15 01:15:18 2011
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=23
System State dumped to trace file /oracle/admin/sptdi/bdump/sptdi2_reco_70420.tr
c
Thu Sep 15 01:37:23 2011
MMNL absent for 5247 secs; Foregrounds taking over
Thu Sep 15 01:37:24 2011
WARNING: inbound connection timed out (ORA-3136)
Thu Sep 15 01:37:24 2011
WARNING: inbound connection timed out (ORA-3136)
Thu Sep 15 01:37:24 2011
WARNING: inbound connection timed out (ORA-3136)
Thu Sep 15 01:37:24 2011
WARNING: inbound connection timed out (ORA-3136)
Thu Sep 15 01:37:24 2011
WARNING: inbound connection timed out (ORA-3136)
Thu Sep 15 01:37:24 2011
WARNING: inbound connection timed out (ORA-3136)如果有必林,再上传trc文件。
谢谢
解决方案 »
- 请问这样的结果是为什么 ?
- 可以用pl/sql连到xx实例上,怎样知道这个实例的ip
- 关于Oracle导入数据的问题
- 求一SQL 分组语句!
- 如何切分字符串問題?
- 未启用特性: Materialized view rewrite,请高手帮忙,该什么处理.
- managent server 无法启动是为什么???
- 打了震荡波补丁后,oms不能启动了,怎么解决?
- oracle9安装问题运行 runinstall 出现cannot execute binary file ?
- 请问数据库设计有大家公认的工具吗?还是只是一些规范,用什么都可以
- 紧急问题,昨天我查询的数据库有100条记录,今天一查只有80条记录了。
- 如何从Oracle 迁移到 Mongo DB
这个版“Oracle入门与认证”的版主,一个名字叫“warehouse”的人。
(打开上面链接,直接搜索warehouse也能找到)
他应该会知道。
明显有过长的等待,这个提示出现,有时将导致客户端无法连接,系统的CPU占用为100%建议根据pid = 96 联查对应的sql语句,并且查看v$session_wait,根据sid联查sql也行。
肯定是有问题的sql。
是RAC,你下面给的那个网址看了,是解决 3136 的。
上面的那些咋搞呢??
是表观。上面提供的一些3136的链接,有些事在虚拟机的实验中,机器性能导致的,所以扩大所谓的inbound_timeout的方式解决,对这个case应该没有特别的帮助这个case的原因
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=96
System State dumped to trace file /oracle/admin/sptdi/udump/sptdi2_ora_619084.trcRAC环境资源死锁导致问题。究竟是什么资源或者进程导致死锁,提供一下上面的trc文件,看是否可以从中找到根据。
这个时候数据库是Hang着的,进不去。
用awk看了trace 文件,说是 cursor: pin S wait on X。
但没有找到引起的sql。出现这种情况时,解决是kill 掉连接,当把产生这个 X 锁的连接 干掉后,数据库可以恢复正常,但是要找到根本的原因,还没有找到
高手!!分析的好。
我把trace文件用awk 拿出来,因为原来的trace文件太大了。要不把 awk后的trace 文件发你邮箱你帮我解决一下。