RE: STATSPACK - Rollback per transaction %

IIRC, when you issue a rollback and there isn't actually anything to be rolled back, then \ the 'transaction rollbacks' value in v$sysstat will not be incremented - only the 'user \ rollbacks' will be incremented. Someone please correct me if I'm wrong.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Ken Payton Sent: Wednesday, December 28, 2005 7:00 AM To: bnsarma_at_gmail.com
Cc: Oracle-L
Subject: STATSPACK - Rollback per transaction %

You might want to check your application connection pooling. A connection pool might rollback a pre-established connection before returning it to the pool, regardless of whether something is being rolled back or not.

. . .

In this case, since you do not actually have anything to rollback you are probably fine.

Kenny

Privileged/Confidential Information may be contained in this message or attachments \ hereto. Please advise immediately if you or your employer do not consent to Internet email \ for messages of this kind. Opinions, conclusions and other information in this message \ that do not relate to the official business of this company shall be understood as neither \ given nor endorsed by it.

--
http://www.freelists.org/webpage/oracle-l