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, but no rollback activity

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

From: mm <mm_song_at_yahoo.com>
Date: 30 Sep 2004 11:47:26 -0700
Message-ID: <97d125e7.0409301047.6e318111@posting.google.com>


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

Original text of this message

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