| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_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_at_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_at_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_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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suhen Pather INET: PatherS5_at_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_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). ------_=_NextPart_001_01C027A9.FE6FE078 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printableReceived on Tue Sep 26 2000 - 06:07:43 CDT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>RE: Lock Table</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>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.</FONT></P>
<P><FONT SIZE=3D2>Lisa</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Suhen Pather [<A =
HREF=3D"mailto:PatherS5_at_telkom.co.za">mailto:PatherS5_at_telkom.co.za</A>]<= /FONT>
<BR><FONT SIZE=3D2>Sent: Tuesday, September 26, 2000 5:56 AM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: Re: Lock Table</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=3D2>Yes Oracle is clever enough to unlock the =
records.</FONT>
<BR><FONT SIZE=3D2>I think it is pmon which will go and release locks =
held by a user after</FONT>
<BR><FONT SIZE=3D2>the users session is aborted</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>HTH</FONT>
<BR><FONT SIZE=3D2>Suhen</FONT>
</P>
<P><FONT SIZE=3D2>>>> AhmadS_at_ipa.edu.sa 09/26/00 11:35AM =
>>></FONT>
<BR><FONT SIZE=3D2>Hi</FONT>
</P>
<P><FONT SIZE=3D2>My question is some of the users are turning off =
their PC while they</FONT>
<BR><FONT SIZE=3D2>are</FONT>
<BR><FONT SIZE=3D2>locking the record, does oracle unlock the record if =
the user just shut</FONT>
<BR><FONT SIZE=3D2>down</FONT>
<BR><FONT SIZE=3D2>his PC while locking. What is the process Oracle =
Use.. </FONT>
</P>
<P><FONT SIZE=3D2>Thanks</FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A =
HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A> </FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Said Talsam Ahmed</FONT>
<BR><FONT SIZE=3D2> INET: AhmadS_at_ipa.edu.sa </FONT>
</P>
<P><FONT SIZE=3D2>Fat City Network Services -- (858) =
538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California -- Public Internet = access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------= -----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
ORACLE-L</FONT>
<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =
from). You may</FONT>
<BR><FONT SIZE=3D2>also send the HELP command for other information =
(like subscribing).</FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A =
HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Suhen Pather</FONT>
<BR><FONT SIZE=3D2> INET: PatherS5_at_telkom.co.za</FONT>
</P>
<P><FONT SIZE=3D2>Fat City Network Services -- (858) =
538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California -- Public Internet = access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------= -----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
ORACLE-L</FONT>
<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =
from). You may</FONT>
 |
 |