Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: STATSPACK: high Rollback per trans % 99.50, but no Rollback Activity
Thank you, German. Could you give some suggestion how to check application?
Thanks very much.
GermanJackson_at_gmail.com (GermanJackson) wrote in message news:<6612a67e.0409291121.33beea4d_at_posting.google.com>...
> 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.
>
>
Received on Thu Sep 30 2004 - 13:49:10 CDT