| a lot of rollback problem [message #266414] |
Mon, 10 September 2007 16:17  |
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  |
 |
Michel Cadot
Messages: 68704
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
