Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Client connection crashes and Rollback..

429359Sep 15 2004 — edited Sep 15 2004

Hi,

I'm running into a crazy oracle's behavior...when a client application crash in the middle of a transaction, oracle keeps the locks on tables updated in the transaction whereas the connection has been killed!

By client application crash, I mean for instance that the computer of the client is suddenly rebooted (power failure for instance) and in this case oracle keeps the locks on the uncommited transaction. why it doesn't rollback the transaction belonging to a killed connection? is it a parameter to set?
If not, how do huge company does? (on huge website for instance)

Thanks for your quick help

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 13 2004

Added on Sep 15 2004

#general-database-discussions

8 comments

1,286 views