Re: STATSPACK: high Rollback per trans % 99.50, but no Rollback Activity

You have a high number of user rollbacks. The number of user rollbacks is 4887.

    this corresponds to 13.3 /sec or
    1.0 per transaction.

You can calculate that yourself by performing the following calculation;

    user rollbacks / (user commits + user rollbacks) * 100

You have to check your application

--J.

mm_song_at_yahoo.com (mm) wrote in message news:<97d125e7.0409290614.6719d206_at_posting.google.com>...
> All,
>
> I had the statspack report with a wierd issue: very high
> Rollback per transaction %: 99.49
> but other rollback statistics don't show many rollbacks.
> rollback changes - undo records a 0 0.0
> 0.0
> transaction rollbacks 0 0.0
> 0.0
> user rollbacks 4,887 13.3
> 1.0
>
> I have no idea how to tune this. I would appreciate any assistance
> that tell me the steps I should go further, or any clues I can try.
> Thanks much.
Received on Wed Sep 29 2004 - 14:21:28 CDT