Go to the FreeLists Home Page Home Signup Help Login
 



Browse oracle-l: This Month's ArchiveMain Archive PageRelated postsPrevious by DateNext by Date

Re: Rollback per transaction %:73 %?

  • From: "Nigel Thomas" <nigel.cl.thomas@xxxxxxxxxxxxxx>
  • To: VIVEK_SHARMA@xxxxxxxxxxx
  • Date: Thu, 31 Jul 2008 10:13:06 +0100
Vivek

Some applications report unusually high rollback rates because "no-work
transactions" are ended with a rollback rather than a commit. So you would
see sequences of one or more selects (but no DML) followed by a rollback
rather than a commit. I seem to recall this being a feature of some JDBC
drivers?

You may be able to change driver settings to avoid this - or in fact it may
not be a problem at all.

Regards Nigel

Other related posts:

  • Rollback per transaction %:73 %?
  • RE: Rollback per transaction %:73 %?
  • RE: Rollback per transaction %:73 %?
  • RE: Rollback per transaction %:73 %?
  • Re: Rollback per transaction %:73 %?
  • RE: Rollback per transaction %:73 %?
  • Re: Rollback per transaction %:73 %?
  • RE: Rollback per transaction %:73 %?
  • RE: Rollback per transaction %:73 %?




  • [ Home | Signup | Help | Login | Archives | Lists ]

    All trademarks and copyrights within the FreeLists archives are owned by their respective owners.
    Everything else ©2008 Avenir Technologies, LLC.