在10.2.0.1中,我们使用dbms_transaction.local_transaction_id来获得XID,这个在某些时候,因为bug,会造成600错误。

下面是OracleSupport上面的解释:

Bug 7330258  OERI[15470] during call to DBMS_TRANSACTION.local_transaction_id

This note gives a brief overview of bug 7330258.
The content was last updated on: 27-MAY-2009
Click here for details of each of the sections below.

Affects:

Product (Component) Oracle Server (Rdbms)
Range of versions believed to be affected Versions < 11.2
Versions confirmed as being affected
Platforms affected Generic (all / most platforms affected)

Fixed:

This issue is fixed in

Symptoms:

Related To:

Description

In certain circumstances, a call to DBMS_TRANSACTION.local_transaction_id
may result in an ORA-600 [15470].

Workaround
 Do not call DBMS_TRANSACTION.local_transaction_id when a recursive
 transaction, but no user transaction, is active.

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.

我们在CAPAA

ASSETCHECK          583        605  行分别应用了dbms_transaction.local_transaction_id;建议在10.2.0.4版本以下安装的时候注意。




Related posts

coded by nessus
分享:  DeliciousGReader鲜果豆瓣CSDN网摘
Trackback

no comment untill now

Sorry, comments closed.

无觅相关文章插件