RE: Lock Table

Message-Id: <10631.117850@fatcity.com> From: "Koivu, Lisa" Date: Tue, 26 Sep 2000 07:07:43 -0400 Subject: RE: Lock Table This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C027A9.FE6FE078 Content-Type: text/plain; charset="iso-8859-1" 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, when connected to the production database because I do not want to take this chance. Lisa -----Original Message----- From: Suhen Pather [mailto:PatherS5@telkom.co.za] Sent: Tuesday, September 26, 2000 5:56 AM To: Multiple recipients of list ORACLE-L Subject: Re: Lock Table 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 HTH Suhen >>> AhmadS@ipa.edu.sa 09/26/00 11:35AM >>> Hi 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.. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Said Talsam Ahmed INET: AhmadS@ipa.edu.sa 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suhen Pather INET: PatherS5@telkom.co.za 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). ------_=_NextPart_001_01C027A9.FE6FE078 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Lock Table

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, when connected to the = production database because I do not want to take this = chance.

Lisa

-----Original Message-----
From: Suhen Pather [mailto:PatherS5@telkom.co.za]<= /FONT>
Sent: Tuesday, September 26, 2000 5:56 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Lock Table

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

HTH
Suhen

>>> AhmadS@ipa.edu.sa 09/26/00 11:35AM = >>>
Hi

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

Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Said Talsam Ahmed
INET: AhmadS@ipa.edu.sa

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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Suhen Pather
INET: PatherS5@telkom.co.za