Message-Id: <10632.118002@fatcity.com> From: "Eric D. Pierce" Date: Wed, 27 Sep 2000 08:21:40 -0700 Subject: Re:RE: Lock Table On 27 Sep 2000, at 7:10, dgoulet@vicr.com scribbled with alacrity and cogency: Date sent: Wed, 27 Sep 2000 07:10:36 -0800 To: Multiple recipients of list ORACLE-L Send reply to: ORACLE-L@fatcity.com From: dgoulet@vicr.com Subject: Re:RE: Lock Table > > I agree, there appears to be some type of long standing BUG in Oracle. Long time ago, as a student, I really messed up a VAX/VMS machine in a computer lab running Oracle4 when I accidentally started a bad join (forgot the t1.key=t2.key in the "where") on some large tables (at least large for those days), and then rebooted the terminal when "ctrl-break" didn't stop the query. (note: no sql*net involved) Apparently the bad join ran for a long time, and sucked up giant resources. The VMS SysAdmn eventually killed it manually (and made some "pithy" comments to the instructor). :) regards, ep >I > normally get one or two sessions a week where the parent Unix PID or PC died and > the session just will not go away. They just sit there either in a killed or > sniped state forever. ... > ____________________Reply Separator____________________ > Author: "Koivu; Lisa" > Date: 9/26/00 4:02 AM > > IN MOST CASES it does clean up after itself but runaway processes (zombies) > are something I deal with daily. I have my users come and tell me if they > have to control-C out of SQL*Plus, an application, or if their PC reboots, ... > -----Original Message----- > Sent: Tuesday, September 26, 2000 5:56 AM > To: Multiple recipients of list ORACLE-L > > > > Yes Oracle is clever enough to unlock the records. > I think it is pmon which will go and release locks held by a user after > the users session is aborted ... > >>> AhmadS@ipa.edu.sa 09/26/00 11:35AM >>> > > My question is some of the users are turning off their PC while they > are > locking the record, does oracle unlock the record if the user just shut > down > his PC while locking. What is the process Oracle Use..