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...


> 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.

>

>

>