kcrrwkx: nothing to do (end)

现象：

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0

kcrrwkx: nothing to do (start)*** 2012-05-07 22:28:35.989kcrrwkx: nothing to do (end)*** 2012-05-07 22:29:35.995kcrrwkx: nothing to do (end)*** 2012-05-07 22:30:36.007kcrrwkx: nothing to do (end)*** 2012-05-07 22:31:36.014kcrrwkx: nothing to do (end)*** 2012-05-07 22:32:36.023kcrrwkx: nothing to do (end)*** 2012-05-07 22:33:36.029tkcrrxmp: Stopping ARC2 to reduce ARCH processes from 3 to 2kcrrwkx: nothing to do (end)*** 2012-05-07 22:34:41.039kcrrwkx: nothing to do (end)*** 2012-05-07 22:35:41.048kcrrwkx: nothing to do (end)

问题类型：

ORACLE系统BUG

解决办法：

1.   This message has zero impact, and can be ignored. Except that the trace files will be consuming disk space, which can be manually removed or running a cron job to clean up.

2. The one-off patch for fixing this issue is also available for some platforms.   Check metalink.oracle.com --> patches & updates --> simple search --> fill the patch number as : 4883174 and choose your correct OS . Down load the patch for10.2.0.1 or 10.2.0.2 as per your database version.

问题原因：

CauseThe archive trace files generation is caused by

Bug 4883174 ARCHIVE PRODUCES TO MANY LOG ENTRIES ''KCRRWKX: NOTHING TO DO (END)
Fixed in11gand possible in10.2.0.3

Please note that these one-off patches are not regression tested and hence you are advised to apply it on a testserver before applying it on a production box. Please follow the patch readme  for installing this patch.

ReferencesBug 4883174 - Archive Produces To Many Log Entries ''Kcrrwkx: Nothing To Do (End)
Bug 5117016 - Libserver10.A Incorrectly Located In $Oracle_Home/Rdbms/Lib/

参考：

SQL> alter system set log_archive_max_processes=30;