Oracle Server - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 22-Nov-2012***
Goal
Are traces containing the following messages expected diagnostic
traces for 11.2.0.2 ?
在11.2.0.2 跟踪日志中包括下面信息:
CursorDiagnosticsNodes:
ChildNode: ChildNumber=2 ID=37 reason=Authorization Check failed(4)
size=5x4 translation_table_position=31036
original_handle=322122547
4 temp_handle=3221225473 schema=5764 synonym_object_number=0
...
AgedOutCursorDiagnosticNodes:
ChildNode: ChildNumber=0 ID=40 reason=Bind mismatch(13) size=4x4
bind_position=3 original_oacflg=32 original_oacpre=0
new_oacpre=3
...
Fix
The development confirmed
in Bug 11858500
- TRACE FILES GENERATED AFTER UPGRADE TO
11G
which is closed with status 'Not a Bug', that this is expected
behavior.
The tracing occurs every time there is cursor sharing issue and
there is no option to stop the diagnostic data from being
dumped.
The traces themselves do not indicate any relevant issue and can be
ignored.
开发确认升级到11g后产生的跟踪文件以'not a
bug'状态关闭,这是期望的行为。
每次在游标共享问题上发生跟踪,没有选项停机该诊断信息dump.
跟中文件本身不能显示任何相关的问题,该动作可以被忽略。