Errors in file /orcdata/app/oracle/admin/orcl/bdump/orcl_lgwr_553022.trc:
ORA-00494: enqueue [CF] held for too long (more than 900 seconds) by 'inst 1, osid 569372'
Wed Sep 8 15:35:35 2010
System State dumped to trace file /orcdata/app/oracle/admin/orcl/bdump/orcl_lgwr_553022.trc
Killing enqueue blocker (pid=569372) on resource CF-00000000-00000000
by killing session 546.1
Wed Sep 8 15:40:43 2010
Errors in file /orcdata/app/oracle/admin/orcl/bdump/orcl_lgwr_553022.trc:
ORA-00494: enqueue [CF] held for too long (more than 900 seconds) by 'inst 1, osid 569372'
Wed Sep 8 15:41:43 2010
System State dumped to trace file /orcdata/app/oracle/admin/orcl/bdump/orcl_lgwr_553022.trc
Killing enqueue blocker (pid=569372) on resource CF-00000000-00000000
by terminating the process
Wed Sep 8 15:56:47 2010
Errors in file /orcdata/app/oracle/admin/orcl/bdump/orcl_lgwr_553022.trc:
ORA-00494: enqueue [CF] held for too long (more than 900 seconds) by 'inst 1, osid 569372'
Wed Sep 8 15:57:47 2010
System State dumped to trace file /orcdata/app/oracle/admin/orcl/bdump/orcl_lgwr_553022.trc
Killing enqueue blocker (pid=569372) on resource CF-00000000-00000000
by terminating the process
Wed Sep 8 15:58:22 2010
Errors in file /orcdata/app/oracle/admin/orcl/bdump/orcl_lgwr_553022.trc:
ORA-00239: timeout waiting for control file enqueue: held by 'inst 1, osid 569372' for more than 900 seconds
Wed Sep 8 16:11:04 2010
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=70
System State dumped to trace file /orcdata/app/oracle/admin/orcl/udump/orcl_ora_893004.trc
Wed Sep 8 16:12:03 2010
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=61
Wed Sep 8 16:13:16 2010
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=164
Wed Sep 8 16:13:22 2010
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=123
Trace文件记录:
Warning: log write time 24410ms, size 2KB
*** 2010-09-08 15:34:33.215
Unable to get enqueue on resource CF-00000000-00000000 (ges mode req=4 held=6)
Possible local blocker spid=569372 sid=546 sser=1 time_held=1553 secs (ges mode req=6 held=3)
DUMP LOCAL BLOCKER: initiate state dump for KILL BLOCKER
possible owner[11.569372] on resource CF-00000000-00000000
Dumping process info of pid[11.569372] requested by pid[6.553022]
ORA-00494: enqueue [CF] held for too long (more than 900 seconds) by 'inst 1, osid 569372'
Trace文件记录:
*** 2010-09-08 16:11:04.633
*** ACTION NAME) 2010-09-08 16:11:04.609
*** MODULE NAMEShadowServerStub.exe) 2010-09-08 16:11:04.609
*** SERVICE NAMEorcl) 2010-09-08 16:11:04.609
*** SESSION ID457.16551) 2010-09-08 16:11:04.609
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! <<<
row cache enqueue: session: 7000000cb9eeb38, mode: N, request: S
分析:
alert日志中日志切换频率是多少?
select OPTIMAL_LOGFILE_SIZE from V$INSTANCE_RECOVERY;
show parameter mttr
对于这个问题官方提供了2个方法:
1、建议LOG SWITCH 在20-30分钟,以减少对控制文件的争用 参考文档 ID 753290.1
2、描述符合 Bug 7692631
set _kill_controlfile_enqueue_blocker=false
_kill_enqueue_blocker=1
参考文档 ID 779552.1
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7882490/viewspace-673076/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7882490/viewspace-673076/