a lot of rollback problem [message #266414] |
Mon, 10 September 2007 16:17 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
thorin666
Messages: 144 Registered: March 2007
|
Senior Member |
|
|
i am running statspack and i see
rollback per transaction % 98,95
and user rollbacks 44055 5.7 1.0
how can i fix it? is a database problem or an aplication problem?
|
|
|
|
|
Re: a lot of rollback problem [message #266639 is a reply to message #266637] |
Tue, 11 September 2007 04:55 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68678 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
If you can't change the code, then you have to live with your rollback.
The important to see is if statistics "rollback changes - undo records applied" is high or not. This will show you if it is real rollbacks or empty ones.
Regards
Michel
|
|
|