Oracle and process failures

Hi there:

I would sincerely appreciate any answers to the following questions from people that know Oracle.

The question is about how Oracle handles the failure of a user process which has started a transaction. The user process may do something silly (such as divide by zero, or any other bugs that will cause it to crash). Since its transaction holds resources it would be desirable for Oracle to abort this transaction.

Does Oracle do that?
If so, how does it do it? Does it use a timeout that expires if Oracle has not received an operation from a transaction for some time and then abort the transaction?

Also, does Oracle allow the same process to start many independent transactions? If so, will Oracle abort all transactions associated with a failed process?

Again, thanks in advance for your replies.

Peter Triantafillou
triantaf_at_cs.sfu.ca Received on Tue Jan 14 1992 - 18:43:16 CET