oracle 11g 动态游标,oracle_包含游标诊断信息的跟踪 In 11g

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.

跟中文件本身不能显示任何相关的问题，该动作可以被忽略。