ORA-00600: internal error code, arguments: [17087]

tolywang發表於2011-02-11
Bug 7706062 - OERI [17087] following concurrent hard parses on same cursor [ID 7706062.8]

  Modified 20-NOV-2010     Type PATCH     Status PUBLISHED  

Bug 7706062  OERI [17087] following concurrent hard parses on same cursor

 This note gives a brief overview bug 7706062.
 The content was last updated on: 18-NOV-2010
 Click for details of each of the sections below.

Affects:

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

Fixed:

This issue is fixed in

Symptoms:

Related To:

  • (None Specified)

Description

A library cache lock can get into an inconsistent state
if a large number of concurrent hard parses occur against
the same cursor. This can lead to ORA-600 [17087] errors.
 
Workaround
 Try reducing the number of hard parses.
 
HOOKS OERI:17087 LIKELYAFFECTS XAFFECTS_10.2.0.1 XAFFECTS_V10020001 AFFECTS=10.2.0.1 XAFFECTS_10.2.0.2 XAFFECTS_V10020002 AFFECTS=10.2.0.2 XAFFECTS_10.2.0.3 XAFFECTS_V10020003 AFFECTS=10.2.0.3 XAFFECTS_10.2.0.4 XAFFECTS_V10020004 AFFECTS=10.2.0.4 XPRODID_5 PRODUCT_ID=5 PRODID-5 RDBMS XCOMP_RDBMS COMPONENT=RDBMS TAG_OERI OERI FIXED_10.2.0.5 FIXED_WIN:A204P28

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

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-687016/,如需轉載,請註明出處,否則將追究法律責任。

相關文章