Re: rollback per transaction% - Statspack

Comments embedded

On 20 May 2005 03:27:40 -0700, "Thiru" <WantedToBeDBA_at_gmail.com> wrote:

>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??

Yes, definitely.
Think of it: you are rolling back (which means I/O) almost all of your transactions!

Does this situation signifies that
>the application is badly written by developer??

I think 'written' is already said too much, as that would signify there is a design behind it.
>
>Expecting Quick reply,
>Thiru.

Please be aware Usenet is a volunteer business and you can't expect quick replies from volunteer. If you want a quick reply, Metaclick is your friend.

--
Sybrand Bakker, Senior Oracle DBA