Link to home
Start Free TrialLog in
Avatar of xoxomos
xoxomos

asked on

Deadlocks , Rollbacks and Undo

Do rollbacks have any impact on undo activity when Oracle is attempting to break a deadlock?
SOLUTION
Avatar of Franck Pachot
Franck Pachot
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Keep in mind that deadlocks are not caused by database bugs.  They indicate application design flaws or inconsitencies.
Warning: that applies only to application locks (TM table locks and TX row locks). There are a lot of bugs where a deadloack occurs for other internal locks !
Avatar of xoxomos
xoxomos

ASKER

mil gracias