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 -> Re: STATSPACK: high Rollback per trans % 99.50, but no Rollback Activity

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

From: mm <mm_song_at_yahoo.com>
Date: 30 Sep 2004 11:49:10 -0700
Message-ID: <97d125e7.0409301049.475fc3b2@posting.google.com>


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

Original text of this message

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