RE: session commits when PC crashes

i tried out a few things too...
my PC is win95, and i;m running plus33, connecting to 8.1.5

1. when run plus33 from DOS WINDOW, the session DOES NOT commit when closed using ctrl+alt+del, task manager
2. when plus33W is executed, the session COMMIT ALWAYS, when the window is closed (task manager, clicking 'x' )
3. in unix (rs/6000) the session DOES NOT commit when KILLED using kill -9

Now my windows sql*plus is acting wierd.... should i turn on the tracing on the client
to debug ?

Rahul

> ----------
> From: Jeremiah Wilton[SMTP:jeremiah_at_WOLFENET.com]
> Sent: Thursday, March 08, 2001 5:07 AM
> To: Dan Rajkumar
> Cc: Lazy DBA
> Subject: Re: session commits when PC crashes
>
> Rahul said that his data was getting committed when he closes the
> window. This is definitely unexpected behavior. It is true that if
> you exit properly from SQL*Plus after making DML changes but without
> committing, SQL*Plus will commit for you (improper behavior in my
> opinion, but at least it is documented). It is not expected, however,
> that abnormal terminations (like closing the SQL*Plus window) should
> leave the data committed.
>
> I was curious about this. Here are some interesting scenarios I tried
> out, which basically show that closing the window does not leave the
> data committed. Therefore, I'm still curious what application Rahul
> is using, because it doesn't sound like it is SQL*Plus.
>
> 1. On Unix, using SQL*Plus v8.1.6:
>
> A. SQL> insert into jeremiah values ('a');
> SQL> exit
> Disconnected from Oracle8i...
> *COMMITTED*
>
> B. SQL> insert into jeremiah values ('a');
> (hit <SHIFT>+<CTRL>+|)
> Quit (core dumped)
> *NOT COMMITTED*
>
> C. SQL> insert into jeremiah values ('a');
> (Terminate SQL*Plus by sending it a SIGTERM from another process)
> (kill -TERM 25461)
> Terminated
> *NOT COMMITTED*
>
> 2. On Windows, using the SQL*Plus GUI (SQLPLUSW.EXE, v8.1.6):
>
> A. SQL> insert into jeremiah values ('a');
> SQL> exit
> *COMMITTED*
>
> B. SQL> insert into jeremiah values ('a');
> (Close the SQL*Plus window by clicking the "X" in the upper right
> corner)
> *NOT COMMITTED*
>
> C. SQL> insert into jeremiah values ('a');
> (Kill the SQL*Plus process by clicking "End Process" in the Task
> Manager)
> *NOT COMMITTED*
>
> 3. On Windows, using the SQL*Plus DOS command line (SQLPLUS.EXE, v.8.1.6)
>
> A. SQL> insert into jeremiah values ('a');
> SQL> exit
> *COMMITTED*
>
> B. SQL> insert into jeremiah values ('a');
> (Close the DOS window by clicking the "X" in the upper right corner)
> *NOT COMMITTED*
>
> C. SQL> insert into jeremiah values ('a');
> (Kill the SQL*Plus process by clicking "End Process" in the Task
> Manager)
> *NOT COMMITTED*
>
> --
> Jeremiah Wilton http://www.wolfenet.com/~jeremiah
>
>
> On Wed, 7 Mar 2001, Dan Rajkumar wrote:
>
> > Oracle will rollback the transaction only if there is an abnormal exit
> > during statement execution. If you close your SQL worksheet/SQL*Plus
> > session while the insert is in progress (and therefore not complete),
> then
> > PMON will rollback the transaction. In your case, the statement
> completed
> > normally. Thus, even if you close the session without issuing the
> commit,
> > it will commit.
> >
> > ----- Original Message -----
> > From: Ashish Shah
> >
> > sure it does. I just tested it through sqlplus and
> > also sql-worksheet. I inserted a row and close the
> > window without commit. row is there now !!
> >
> > --- Jeremiah Wilton <jeremiah_at_WOLFENET.com> wrote:
> > > On Tue, 6 Mar 2001, Rahul wrote:
> > >
> > > > the oracle session will commit if the session is
> > > > terminated by closing the window or re-booting
> > > > the PC etc....
> > > >
> > > > is there a way (parameter) to prevent this ?
> > >
> > > This should not happen. What client software are
> > > you using?
>
>
> --------
> Think you know someone who can answer the above question? Forward it to
> them!
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
> to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com
> Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rahul
  INET: rahul_at_ratelindo.co.id

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).