From rahul@ratelindo.co.id Thu, 08 Mar 2001 00:22:10 -0800 From: Rahul Date: Thu, 08 Mar 2001 00:22:10 -0800 Subject: RE: session commits when PC crashes Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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@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 ++|) > 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 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@LAZYDBA.com > to subscribe send a blank email to oracledba-subscribe@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@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@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).