enq: HW contention occured at the top wait event as a result of multiple sessions insert data into the same table. This event is the competition for high water mark lock. Oracle Support confirmed that we were hitting a bug 9407198. The bug's summary is below..
Bug 9407198 "LOG ERRORS INTO" can cause OERI[kcb***] or hang scenarios
This note gives a brief overview of bug 9407198.
The content was last updated on: 23-FEB-2011
Click here for details of each of the sections below.
The content was last updated on: 23-FEB-2011
Click here for details of each of the sections below.
Affects:
Product (Component) Oracle Server (Rdbms) Range of versions believed to be affected Versions BELOW 12.1 Versions confirmed as being affected Platforms affected Generic (all / most platforms affected)
Fixed:
This issue is fixed in
Symptoms: | Related To: |
|
Description
"LOG ERRORS INTO" can cause various ORA-600 errors, typically
beginning ORA-600 [kcb*], or hangs, if an ORA-1578 or ORA-1115
error occurs during processing of the SQL statement.
Workaround:
Address the cause of the triggering error (ie: ORA-1578 or ORA-1115).
or
Do not use the error logging clause on SQL statements
Note:
This fix only addresses the scenario of ORA-1578 and
ORA-1115 causing a subsequent problem during error logging.
See bug 9150510 for a similar issue if the triggering error
is an ORA-3113 error.
No comments:
Post a Comment