Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Implicit Commit...pls remind me.
If your connection terminated abnormally without issuing a commit or
rollback, then PMON will rollback any uncommitted transactions. As Sybrand
pointed out, SQL*PLUS issues an implicit commit when you issue an EXIT
command. However, closing a SQL*PLUS window on Windows with entering EXIT
is similar to a crash condition.
If your windows client locked up without issuing a commit or rollback, then PMON will rollback the uncommitted work. The EXIT command in SQL*PLUS is specific to the tool. Some third party tools have the equivalent of autocommit, so the exact behavior would be tool specific, and it would depend how or where your tool crashed.
Unless PL/SQL Developer has an autocommit mode, I would guess that any uncommitted transactions are rolled back when the tool locks.
Good Luck!
-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Chris Weiss mailto:chris_at_hpdbe.com www.hpdbe.com High Performance Database Engineering Available for long and short term contracts "R Chin" <rchin_at_panix.com> wrote in message news:ab19ha$3qe$1_at_reader1.panix.com...Received on Sat May 04 2002 - 22:02:11 CDT
> 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.
>
>
>