Home » RDBMS Server » Performance Tuning » a lot of rollback problem
a lot of rollback problem [message #266414] Mon, 10 September 2007 16:17 Go to next message
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 #266449 is a reply to message #266414] Mon, 10 September 2007 23:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Ask your application (surely one ported from a Sybase or SQL Server one) to no more rollback for nothing.

Regards
Michel
Re: a lot of rollback problem [message #266637 is a reply to message #266449] Tue, 11 September 2007 04:50 Go to previous messageGo to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member

michael, i don't understand you what do you mean with "ask your aplication"?
the app is a 3rd company app from a private developer (not sybase or sqlserver)

thnx for your help as ever Wink

[Updated on: Tue, 11 September 2007 04:51]

Report message to a moderator

Re: a lot of rollback problem [message #266639 is a reply to message #266637] Tue, 11 September 2007 04:55 Go to previous message
Michel Cadot
Messages: 64098
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


Previous Topic: How many connection are on line
Next Topic: Error when I try to connect to a database using sqlplus
Goto Forum:
  


Current Time: Fri Dec 02 12:10:21 CST 2016

Total time taken to generate the page: 0.18092 seconds