Ora 8177 On index Block splits ???
RDBMS Version: 10.2.0.3.0
Operating System and Version: Linux 2.6.9-55.0.9.ELsmp
Error Number (if applicable): ORA 08177
Product (i.e. SQL*Loader, Import, etc.): Database server
Product Version: 10.2.0.3.0
All,
We are currently doing some test of our banking application with oracle isolation level set to serializable. This is a application that has been ported over from proprietary software/database to oracle.
While running a suite of tests we frequently encounter ORA-08177 "cannot serialize access" errors. The errors are being thrown on transactions that insert into a message log table. These errors can be reproduced with a single session. While we do error trap for this condition and issue a transaction restart, it does not appear to solve all cases, we appear to fail on the exact same test even on subsequent attempts.
On researching this issue I read about index block splits and how they could possibly cause this condition. My questions are:
1) Are index block splits known to cause this problem?
2) Are there ways to mitigate occurrences of this issue with
changes to the database setting apart from going back to the default oracle isolation level.
3) Is there oracle documentation on causes of ORA 08177 apart from the genuine cases where two sessions do collide..
thanks in advance for your time..
badri