Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Implicit Commit...pls remind me.

Re: Implicit Commit...pls remind me.

From: R Chin <rchin_at_panix.com>
Date: Sat, 4 May 2002 14:35:11 -0400
Message-ID: <ab19ha$3qe$1@reader1.panix.com>


But what I am wondering is..
Can PMON really tell if a SQL+ client
actually crashed or just exited (normally or else)

What about a 3rd party tool like PL/SQL Developer ? If it hangs and I have to kill it the windoz way...will my (incomplete) transactions be rolled-back ?

Thanks
Rob

Sybrand Bakker wrote in message ...
>A client exiting sql*plus will *always* commit, unless it explicitly rolls
>back.
>A crash however will force pmon to roll the transaction back.
Received on Sat May 04 2002 - 13:35:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US