Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> rollback per transaction% - Statspack
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