Re: Rollback per transaction %:73 %?

From: Nigel Thomas <nigel.cl.thomas_at_googlemail.com>
Date: Thu, 31 Jul 2008 10:13:06 +0100
Message-ID: <53258cd50807310213t3c8c0f90ka442ea092839b93b@mail.gmail.com>


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

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jul 31 2008 - 04:13:06 CDT

Original text of this message