Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> rollback per transaction% - Statspack

rollback per transaction% - Statspack

From: Thiru <WantedToBeDBA_at_gmail.com>
Date: 20 May 2005 03:27:40 -0700
Message-ID: <1116584860.491531.141600@g44g2000cwa.googlegroups.com>


Hi All,

   I want to know the root cause, which is making rollback per transaction% to 99.57.

   Also i noticed user rollbacks per transaction is 1. (i have attached the part of the statspack below)
Does this mean that there is no transaction happened at all?? Instance Activity Stats for DB: LMS Instance: ora9 Snaps: 931 -932

Statistic                         Total     per Second    per Trans
-------------------------       ------------------ --------------
user calls                      21,018,850    1,459.7      5.4
user commits                    16,699        1.2          0.0
user rollbacks                  3,860,461     268.1        1.0

   I don't see any failed transaction(I am doing web transaction using load testing tools which hits database). At the end of the test, i found that database is normal and its updated as expected.   Is this situation really problem?? Does this situation signifies that the application is badly written by developer??

Expecting Quick reply,
Thiru. Received on Fri May 20 2005 - 05:27:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US