Re: STATSPACK: high Rollback per trans, but no rollback activity

On 29 Sep 2004 08:48:26 -0700, mm_song_at_yahoo.com (mm) wrote:

>All,
>
>I had a statspack report with high Rollback Per Trans:
> Rollback per transaction %: 99.49
>
>But other rollback activities look not that bad:
>
> 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 why and how to resolve the problem of high RPT. I
>would appreciate any assistance that give the steps to go further, or
>any clues I can try.
>
>Thanks very much.
>
>MS

Look at the other rollback activities: You have 4887 rollbacks!!! Almost all of your transactions are being rolled back. You have a serious application problem, not a database problem. Find out why all transactions are being rolled back.

--
Sybrand Bakker, Senior Oracle DBA