Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: STATSPACK: high Rollback per trans, but no rollback activity
Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl> wrote in message news:<ugsll0t51p2ma2ucmfgth7s8461b65a6rv_at_4ax.com>...
Thanks, Sybrand. I knew that almost each of the application's
transaction got rolled back and knew how to find which session did
that. but what should I do after i found that session? The session
is from a big application run with a lot of sql routines. Any clue to
cure this bad situation or any suggestion for narrowing search spots?
Thanks again.
>
> 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.
Received on Thu Sep 30 2004 - 13:47:26 CDT