检查发现一个DG数据库产生了一个很大trace文件,而且还在不断增长,看里面的内容一直是
LET: next scn before krvxrolf.
scn: 0x0000.00000000
LET: next scn after krvxrolf.
scn: 0xffff.ffffffff
内容在不停的循环,检查发现这个进程是个并发进程P000,等待事件为:LogMiner: reader waiting for more redo,这个进程的父进程是一个后台进程LSP0(Logical Standby Process),感觉这应该不是一个可调整的问题。果然oracle回复这是个bug:
bug内容如下:
主题: |
Bug 6994160 - Capture reader process constantly writing messages to trace file |
|
文档 ID: |
6994160.8 |
类型: |
PATCH |
|
Modified Date: |
14-JUL-2009 |
状态: |
PUBLISHED |
Bug 6994160 Capture reader process constantly writing messages to trace file
This note gives a brief overview of bug 6994160.
The content was last updated on: 10-JUL-2009
Click for details of each of the sections below.
Affects:
Product (Component) |
Oracle Server (Rdbms) |
Range of versions believed to be affected |
(Not specified) |
Versions confirmed as being affected |
|
Platforms affected |
Generic (all / most platforms affected) |
Fixed:
Description
Logminer redo reader process may create large trace files
with content of the form:
LET: next scn before krvxrolf.
scn: 0x0000.00000000
LET: next scn after krvxrolf.
scn: 0xffff.ffffffff
Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. Always consult with Oracle Support for advice. |
References
(This link will only work for PUBLISHED bugs)
Information on the sections in this article
阅读(3207) | 评论(0) | 转发(0) |