Re:RE: Lock Table

From: Eric D. Pierce <PierceED_at_csus.edu>
Date: Wed, 27 Sep 2000 08:21:40 -0700
Message-Id: <10632.118002@fatcity.com>

On 27 Sep 2000, at 7:10, dgoulet_at_vicr.com scribbled with alacrity and cogency:

Date sent:      	Wed, 27 Sep 2000 07:10:36 -0800
To:             	Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Send reply to:  	ORACLE-L_at_fatcity.com
From:           	dgoulet_at_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" <lkoivu_at_qode.com>
> 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_at_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..
Received on Wed Sep 27 2000 - 10:21:40 CDT