Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> STATSPACK: high Rollback per trans % 99.50, but no Rollback Activity
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.31.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