在生产库上发现了lock table现象，早上同事kill 掉了几个session , 下午检查alert log时发现了一些错误(或信息)，如下：
Fri Jan 07 09:01:40 2011
Thread 1 advanced to log sequence 976 (LGWR switch)
Current log# 1 seq# 976 mem# 0: /data/ccptdb/redo01a.log
Current log# 1 seq# 976 mem# 1: /data/ccptdb/redo01b.log
Fri Jan 07 09:01:40 2011
Archived Log entry 757 added for thread 1 sequence 975 ID 0xbd6779f9 dest 1:
Fri Jan 07 09:19:55 2011
opiodr aborting process unknown ospid (21767) as a result of ORA-28
Fri Jan 07 09:24:22 2011
opiodr aborting process unknown ospid (22359) as a result of ORA-28
Fri Jan 07 09:30:37 2011
Thread 1 advanced to log sequence 977 (LGWR switch)
Current log# 2 seq# 977 mem# 0: /data/ccptdb/redo02a.log
Current log# 2 seq# 977 mem# 1: /data/ccptdb/redo02b.log
Fri Jan 07 09:30:37 2011
Archived Log entry 758 added for thread 1 sequence 976 ID 0xbd6779f9 dest 1:
Fri Jan 07 09:36:02 2011
opiodr aborting process unknown ospid (23918) as a result of ORA-28
Fri Jan 07 09:37:15 2011
opidcl aborting process unknown ospid (21118) as a result of ORA-28
Fri Jan 07 09:37:15 2011
opidcl aborting process unknown ospid (19652) as a result of ORA-28
Fri Jan 07 09:45:40 2011
Thread 1 advanced to log sequence 978 (LGWR switch)
Current log# 3 seq# 978 mem# 0: /data/ccptdb/redo03a.log
Current log# 3 seq# 978 mem# 1: /data/ccptdb/redo03b.log
Fri Jan 07 09:45:40 2011
Archived Log entry 759 added for thread 1 sequence 977 ID 0xbd6779f9 dest 1:
Fri Jan 07 09:49:42 2011
Thread 1 advanced to log sequence 979 (LGWR switch)
Current log# 4 seq# 979 mem# 0: /data/ccptdb/redo04a.log
Current log# 4 seq# 979 mem# 1: /data/ccptdb/redo04b.log
Fri Jan 07 09:49:42 2011
查询了一下， Bug 6377339 - Misleading alert log message for "opiodr aborting" [ID 6377339.8]
Fixed:
奇怪了， 我的版本就是 11.2.0.1 , 没有看到有修复......
This issue is fixed in