正式库解决不了的问题
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文件。
谢谢


------解决方案--------------------
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=96
明显有过长的等待，这个提示出现，有时将导致客户端无法连接，系统的CPU占用为100%

建议根据pid = 96 联查对应的sql语句，并且查看v$session_wait，根据sid联查sql也行。
肯定是有问题的sql。

------解决方案--------------------
WARNING: inbound connection timed out (ORA-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.trc

RAC环境资源死锁导致问题。

究竟是什么资源或者进程导致死锁，提供一下上面的trc文件，看是否可以从中找到根据。