Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: dbms_lock.sleep()
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_01BFC3FC.91D6DA18
Content-Type: text/plain;
charset="iso-8859-1"
I have several packages and jobs that use this and have for over a year. I have not had a problem with it yet.
--Chris
Chris.Bowes_at_Kosa.com
-----Original Message-----
From: PRIBILLA.Michael_at_EU.DRAGOCO.COM
[mailto:PRIBILLA.Michael_at_EU.DRAGOCO.COM]
Sent: Monday, May 22, 2000 10:16 AM
To: Multiple recipients of list ORACLE-L
Subject: dbms_lock.sleep()
DBAs,
is there any known - negative - side effect when using the above procedure in Oracle 7.x/8.x stored procedures?
I would like to use this procedure in an interface scenario where the interface procedures are called in short intervals of 5 to 20 seconds.
I already implemented this in the test environments without problems but I just want to make sure there is no potential risk.
Any comment is wellcome.
TIA,
Michael
------_=_NextPart_001_01BFC3FC.91D6DA18
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>dbms_lock.sleep()</TITLE>
<META content="MSHTML 5.00.2919.6307" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=345284314-22052000>I have
several packages and jobs that use this and have for over a year. I have
n</SPAN></FONT><FONT color=#0000ff face=Arial size=2><SPAN
class=345284314-22052000>ot had a problem with it yet.</SPAN></FONT></DIV>
<DIV> </DIV>
<P><FONT face=Arial size=2>--Chris</FONT> <BR><FONT face=Arial
size=2>Chris.Bowes_at_Kosa.com</FONT> </P>
<DIV> </DIV>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader><FONT face="Times New Roman"
size=2>-----Original Message-----<BR><B>From:</B>
PRIBILLA.Michael_at_EU.DRAGOCO.COM
[mailto:PRIBILLA.Michael_at_EU.DRAGOCO.COM]<BR><B>Sent:</B> Monday, May 22, 2000
10:16 AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B>
dbms_lock.sleep()<BR><BR></DIV></FONT>
<P><FONT face=Arial size=2>DBAs,</FONT> </P>
<P><FONT face=Arial size=2>is there any known - negative - side effect when
using the above procedure in Oracle 7.x/8.x stored procedures?</FONT> </P>
<P><FONT face=Arial size=2>I would like to use this procedure in an interface
scenario where the interface procedures are called in short intervals of 5 to
20 seconds.</FONT></P>
<P><FONT face=Arial size=2>I already implemented this in the test environments
without problems but I just want to make sure there is no potential
risk.</FONT></P>
<P><FONT face=Arial size=2>Any comment is wellcome.</FONT> </P>
<P><FONT face=Arial size=2>TIA,</FONT> <BR><FONT face=Arial
size=2>Michael</FONT> </P><BR></BLOCKQUOTE></BODY></HTML>
Received on Mon May 22 2000 - 09:45:26 CDT
![]() |
![]() |