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

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

From: mm <mm_song_at_yahoo.com>
Date: 29 Sep 2004 07:14:40 -0700
Message-ID: <97d125e7.0409290614.6719d206@posting.google.com>


All,

I had the statspack report with a wierd issue: very high

    Rollback per transaction %: 99.49
but other rollback statistics don't show many rollbacks.

   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 how to tune this. I would appreciate any assistance that tell me the steps I should go further, or any clues I can try.   Thanks much. Received on Wed Sep 29 2004 - 09:14:40 CDT

Original text of this message

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