From oracle-l-bounce@freelists.org Tue Sep 27 18:15:34 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8RNFYki025171 for ; Tue, 27 Sep 2005 18:15:34 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j8RNFH6H025155 for ; Tue, 27 Sep 2005 18:15:17 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 411E21EFC12; Tue, 27 Sep 2005 18:15:12 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 06459-07; Tue, 27 Sep 2005 18:15:12 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B326C1EFC01; Tue, 27 Sep 2005 18:15:11 -0500 (EST) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 Content-Class: urn:content-classes:message MIME-Version: 1.0 Priority: normal Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5C3B8.C2523676" Subject: RE: Select statement hangs over DBlink (Intermittent) Date: Tue, 27 Sep 2005 17:11:15 -0600 Message-ID: <17CAB0BF27BCFC47B0E4554A0E2F962B87350B@fiji.arraybp.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Select statement hangs over DBlink (Intermittent) thread-index: AcXDte+Ks5pMk0CzRDaPNjQlVRYANQAAsctw From: "Reidy, Ron" To: , "oracle-l" X-OriginalArrivalTime: 27 Sep 2005 23:11:15.0424 (UTC) FILETIME=[C27C1E00:01C5C3B8] X-archive-position: 25972 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Ron.Reidy@arraybiopharma.com Precedence: normal Reply-To: Ron.Reidy@arraybiopharma.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.7 required=5.0 tests=AWL,BAYES_00, HTML_FONTCOLOR_BLUE,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5C3B8.C2523676 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Network problems? =20 -- Ron Reidy Lead DBA Array BioPharma, Inc. -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Sami Seerangan Sent: Tuesday, September 27, 2005 4:42 PM To: oracle-l Subject: Select statement hangs over DBlink (Intermittent) QUERY c1 refcursor; c2 refcursor; BEGIN BIB_OTP_PKG.get_token_details('123678456',:c1,:c2); END; I am executing the stored procedure which includes select over DB Link. Most of the time it works (> 95%) and few times it hangs. I took 10053 event trace and it says wait event on 'SQL*Net message from dblink' ,'SQL*Net message to dblink' and 'SQL*Net break/reset to dblink'. Any idea what is going wrong here? /opt/oracle/admin/dnet13/udump/dnet131_ora_21694_bib_otp_pkg_03.trc =20 *** TRACE DUMP CONTINUED FROM FILE /opt/oracle/admin/dnet13/udump/dnet131_ora_21694_bib_otp_pkg_02.trc *** =20 EXEC = #3:c=3D0,e=3D1147,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,tim=3D= 951110760122 WAIT #3: nam=3D'SQL*Net message to client' ela=3D 2 p1=3D1650815232 = p2=3D1 p3=3D0 WAIT #3: nam=3D'SQL*Net message from client' ela=3D 496 p1=3D1650815232 = p2=3D1 p3=3D0 QUERY alter session set events '10053 trace name context forever, level 12' =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D PARSING IN CURSOR #3 len=3D69 dep=3D0 uid=3D164 oct=3D42 lid=3D164 tim=3D951110760998 hv=3D2800020113 ad=3D'a5e71f18' alter session set events '10053 trace name context forever, level 12' END OF STMT PARSE = #3:c=3D0,e=3D106,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,tim=3D9= 51110760994 BINDS #3: EXEC = #3:c=3D0,e=3D141,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,tim=3D9= 51110761210 WAIT #3: nam=3D'SQL*Net message to client' ela=3D 2 p1=3D1650815232 = p2=3D1 p3=3D0 WAIT #3: nam=3D'SQL*Net message from client' ela=3D 923 p1=3D1650815232 = p2=3D1 p3=3D0 QUERY BEGIN BIB_OTP_PKG.get_token_details('0058020258',:c1,:c2); END; =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D PARSING IN CURSOR #3 len=3D65 dep=3D0 uid=3D164 oct=3D47 lid=3D164 tim=3D951110762903 hv=3D727016698 ad=3D'a5f7d828' BEGIN BIB_OTP_PKG.get_token_details('0058020258',:c1,:c2); END; END OF STMT PARSE = #3:c=3D0,e=3D306,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,tim=3D9= 51110762895 BINDS #3: bind 0: dty=3D102 mxl=3D04(04) mal=3D00 scl=3D00 pre=3D00 oacflg=3D01 = oacfl2=3D0 size=3D16 offset=3D0 bfp=3Dffffffff7c95fb48 bln=3D04 avl=3D04 flg=3D05 value=3D Dump of memory from 0xFFFFFFFF7C95FB48 to 0xFFFFFFFF7C95FB4C FFFFFFFF7C95FB40 00000000 [....] bind 1: dty=3D102 mxl=3D04(04) mal=3D00 scl=3D00 pre=3D00 oacflg=3D01 = oacfl2=3D0 size=3D0 offset=3D8 bfp=3Dffffffff7c95fb50 bln=3D04 avl=3D04 flg=3D01 value=3D Dump of memory from 0xFFFFFFFF7C95FB50 to 0xFFFFFFFF7C95FB54 FFFFFFFF7C95FB50 00000000 [....] WAIT #4: nam=3D'SQL*Net message to dblink' ela=3D 4 p1=3D1413697536 = p2=3D1 p3=3D0 *** 2005-09-27 18:03:19.304 WAIT #4: nam=3D'SQL*Net message from dblink' ela=3D 509763902 = p1=3D1413697536 p2=3D1 p3=3D0 WAIT #4: nam=3D'SQL*Net break/reset to dblink' ela=3D 2 p1=3D1413697536 = p2=3D1 p3=3D0 WAIT #4: nam=3D'SQL*Net break/reset to dblink' ela=3D 93 p1=3D1413697536 = p2=3D0 p3=3D0 WAIT #4: nam=3D'single-task message' ela=3D 94523 p1=3D0 p2=3D0 p3=3D0 WAIT #4: nam=3D'SQL*Net message to dblink' ela=3D 3 p1=3D1413697536 = p2=3D28 p3=3D0 WAIT #4: nam=3D'SQL*Net message from dblink' ela=3D 6925 p1=3D1413697536 = p2=3D1 p3=3D0 WAIT #4: nam=3D'SQL*Net message to dblink' ela=3D 1 p1=3D1413697536 = p2=3D1 p3=3D0 WAIT #4: nam=3D'SQL*Net message from dblink' ela=3D 2284 p1=3D1413697536 = p2=3D1 p3=3D0 WAIT #4: nam=3D'SQL*Net message to dblink' ela=3D 3 p1=3D1413697536 = p2=3D1 p3=3D0 WAIT #4: nam=3D'SQL*Net message from dblink' ela=3D 13798 = p1=3D1413697536 p2=3D1 p3=3D0 WAIT #4: nam=3D'SQL*Net message to dblink' ela=3D 2 p1=3D1413697536 = p2=3D1 p3=3D0 WAIT #4: nam=3D'SQL*Net message from dblink' ela=3D 5553 p1=3D1413697536 = p2=3D1 p3=3D0 WAIT #4: nam=3D'SQL*Net message to dblink' ela=3D 1 p1=3D1413697536 = p2=3D1 p3=3D0 WAIT #4: nam=3D'SQL*Net message from dblink' ela=3D 556 p1=3D1413697536 = p2=3D1 p3=3D0 WAIT #4: nam=3D'SQL*Net message to dblink' ela=3D 1 p1=3D1413697536 = p2=3D1 p3=3D0 WAIT #4: nam=3D'SQL*Net message from dblink' ela=3D 2465 p1=3D1413697536 = p2=3D1 p3=3D0 WAIT #4: nam=3D'SQL*Net message to dblink' ela=3D 1 p1=3D1413697536 = p2=3D1 p3=3D0 WAIT #4: nam=3D'SQL*Net message from dblink' ela=3D 335 p1=3D1413697536 = p2=3D1 p3=3D0 WAIT #4: nam=3D'SQL*Net message to dblink' ela=3D 0 p1=3D1413697536 = p2=3D1 p3=3D0 WAIT #4: nam=3D'SQL*Net message from dblink' ela=3D 767 p1=3D1413697536 = p2=3D1 p3=3D0 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D PARSE ERROR #4:len=3D618 dep=3D1 uid=3D168 oct=3D3 lid=3D168 = tim=3D951620661502 err=3D2051 SELECT A.TOKEN_TYPE, B.COLOR, C.LOCATION_NAME, C.HSBC_ENTITY, E.TOKEN_STATUS_DESC CURRENT_STATUS, H.STATUS_CHANGE_DATE IN_ST OCK_DATE, E.TOKEN_STATUS_ID FROM TOKEN_INVENTORY A, TOKEN_ATTRIBUTES B, TOKEN_DISTRIBUTION_LOCATIONS C, TOKEN_INFORMATION D, TOKEN_STATUS E, TOKEN_INFORMATION H WHERE A.SERIAL_NUMBER =3D :B1 AND A.TOKEN_ATTRIBUTE_ID =3D B.TOKEN_ATTRIBUTE_ID AND B.HSBC_ LOCATION_ID =3D C.HSBC_LOCATION_ID AND A.SERIAL_NUMBER =3D = D.SERIAL_NUMBER AND D.CURRENTFLAG =3D 'Y' AND D.TOKEN_STATUS_ID =3D E.TOK EN_STATUS_ID AND D.APPLICATION_NAME =3D E.APPLICATION_NAME AND H.SERIAL_NUMBER =3D A.SERIAL_NUMBER AND H.TOKEN_STATUS_ID =3D 30 EXEC #3:c=3D10000,e=3D509899355,p=3D0,cr=3D0,cu=3D1,mis=3D0,r=3D0,dep=3D0,og=3D= 4,tim=3D9516206623 63 ERROR #3:err=3D2051 tim=3D97445955 WAIT #3: nam=3D'SQL*Net break/reset to client' ela=3D 3 p1=3D1650815232 = p2=3D1 p3=3D0 WAIT #3: nam=3D'SQL*Net break/reset to client' ela=3D 180 = p1=3D1650815232 p2=3D0 p3=3D0 WAIT #3: nam=3D'SQL*Net message to client' ela=3D 2 p1=3D1650815232 = p2=3D1 p3=3D0 WAIT #3: nam=3D'SQL*Net message from client' ela=3D 2155 p1=3D1650815232 = p2=3D1 p3=3D0 QUERY BEGIN BIB_OTP_PKG.get_token_details('0058020234',:c1,:c2); END; =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D This electronic message transmission is a PRIVATE communication which = contains information which may be confidential or privileged. The information is = intended=20 to be for the use of the individual or entity named above. If you are = not the=20 intended recipient, please be aware that any disclosure, copying, = distribution=20 or use of the contents of this information is prohibited. Please notify = the sender of the delivery error by replying to this message, or notify us = by telephone (877-633-2436, ext. 0), and then delete it from your system. ------_=_NextPart_001_01C5C3B8.C2523676 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Message
Network problems?
 
--
Ron=20 Reidy
Lead=20 DBA
Array=20 BioPharma, Inc.
-----Original Message-----
From: = oracle-l-bounce@freelists.org=20 [mailto:oracle-l-bounce@freelists.org] On Behalf Of Sami=20 Seerangan
Sent: Tuesday, September 27, 2005 4:42 = PM
To:=20 oracle-l
Subject: Select statement hangs over DBlink=20 (Intermittent)

QUERY

c1 refcursor;
c2=20 refcursor;
BEGIN BIB_OTP_PKG.get_token_details('123678456',:c1,:c2);=20 END;

I am executing the stored procedure which includes select = over DB=20 Link. Most of the time it works (> 95%) and few times it = hangs.

I took=20 10053 event trace and it says wait event on 'SQL*Net message from = dblink'=20 ,'SQL*Net message to dblink' and 'SQL*Net break/reset to dblink'. Any = idea what=20 is going wrong=20 here?



/opt/oracle/admin/dnet13/udump/dnet131_ora_21694_bib= _otp_pkg_03.trc
 
***=20 TRACE DUMP CONTINUED FROM FILE=20 /opt/oracle/admin/dnet13/udump/dnet131_ora_21694_bib_otp_pkg_02.trc=20 ***
 
EXEC=20 #3:c=3D0,e=3D1147,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,tim=3D= 951110760122
WAIT #3:=20 nam=3D'SQL*Net message to client' ela=3D 2 p1=3D1650815232 p2=3D1 = p3=3D0
WAIT #3:=20 nam=3D'SQL*Net message from client' ela=3D 496 p1=3D1650815232 p2=3D1=20 p3=3D0
QUERY
alter session set events '10053 trace name context = forever,=20 level = 12'
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3DPARSING IN CURSOR #3 len=3D69 dep=3D0 uid=3D164=20 oct=3D42 lid=3D164 tim=3D951110760998 hv=3D2800020113 = ad=3D'a5e71f18'
alter session set=20 events '10053 trace name context forever, level 12'
END OF = STMT
PARSE=20 #3:c=3D0,e=3D106,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,tim=3D9= 51110760994
BINDS=20 #3:
EXEC=20 #3:c=3D0,e=3D141,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,tim=3D9= 51110761210
WAIT #3:=20 nam=3D'SQL*Net message to client' ela=3D 2 p1=3D1650815232 p2=3D1 = p3=3D0
WAIT #3:=20 nam=3D'SQL*Net message from client' ela=3D 923 p1=3D1650815232 p2=3D1=20 p3=3D0
QUERY
BEGIN = BIB_OTP_PKG.get_token_details('0058020258',:c1,:c2);=20 END;
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3DPARSING IN CURSOR #3 len=3D65 dep=3D0 uid=3D164=20 oct=3D47 lid=3D164 tim=3D951110762903 hv=3D727016698 = ad=3D'a5f7d828'
BEGIN=20 BIB_OTP_PKG.get_token_details('0058020258',:c1,:c2); END;
END OF=20 STMT
PARSE=20 #3:c=3D0,e=3D306,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,tim=3D9= 51110762895
BINDS=20 #3:
 bind 0: dty=3D102 mxl=3D04(04) mal=3D00 scl=3D00 pre=3D00 = oacflg=3D01 oacfl2=3D0=20 size=3D16 offset=3D0
   bfp=3Dffffffff7c95fb48 bln=3D04 = avl=3D04=20 flg=3D05
   value=3D
Dump of memory from = 0xFFFFFFFF7C95FB48 to=20 0xFFFFFFFF7C95FB4C
FFFFFFFF7C95FB40      = ;            = =20 00000000           = ;       =20 [....]
 bind 1: dty=3D102 mxl=3D04(04) mal=3D00 scl=3D00 = pre=3D00 oacflg=3D01=20 oacfl2=3D0 size=3D0 offset=3D8
   bfp=3Dffffffff7c95fb50 = bln=3D04 avl=3D04=20 flg=3D01
   value=3D
Dump of memory from = 0xFFFFFFFF7C95FB50 to=20 0xFFFFFFFF7C95FB54
FFFFFFFF7C95FB50=20 00000000           = ;            =      =20 [....]
WAIT #4: nam=3D'SQL*Net message to dblink' ela=3D 4 = p1=3D1413697536 p2=3D1=20 p3=3D0
*** 2005-09-27 18:03:19.304
WAIT #4: nam=3D'SQL*Net message = from=20 dblink' ela=3D 509763902 p1=3D1413697536 p2=3D1 p3=3D0
WAIT #4: = nam=3D'SQL*Net=20 break/reset to dblink' ela=3D 2 p1=3D1413697536 p2=3D1 p3=3D0
WAIT = #4: nam=3D'SQL*Net=20 break/reset to dblink' ela=3D 93 p1=3D1413697536 p2=3D0 p3=3D0
WAIT = #4:=20 nam=3D'single-task message' ela=3D 94523 p1=3D0 p2=3D0 p3=3D0
WAIT = #4: nam=3D'SQL*Net=20 message to dblink' ela=3D 3 p1=3D1413697536 p2=3D28 p3=3D0
WAIT #4: = nam=3D'SQL*Net=20 message from dblink' ela=3D 6925 p1=3D1413697536 p2=3D1 p3=3D0
WAIT = #4: nam=3D'SQL*Net=20 message to dblink' ela=3D 1 p1=3D1413697536 p2=3D1 p3=3D0
WAIT #4: = nam=3D'SQL*Net=20 message from dblink' ela=3D 2284 p1=3D1413697536 p2=3D1 p3=3D0
WAIT = #4: nam=3D'SQL*Net=20 message to dblink' ela=3D 3 p1=3D1413697536 p2=3D1 p3=3D0
WAIT #4: = nam=3D'SQL*Net=20 message from dblink' ela=3D 13798 p1=3D1413697536 p2=3D1 p3=3D0
WAIT = #4: nam=3D'SQL*Net=20 message to dblink' ela=3D 2 p1=3D1413697536 p2=3D1 p3=3D0
WAIT #4: = nam=3D'SQL*Net=20 message from dblink' ela=3D 5553 p1=3D1413697536 p2=3D1 p3=3D0
WAIT = #4: nam=3D'SQL*Net=20 message to dblink' ela=3D 1 p1=3D1413697536 p2=3D1 p3=3D0
WAIT #4: = nam=3D'SQL*Net=20 message from dblink' ela=3D 556 p1=3D1413697536 p2=3D1 p3=3D0
WAIT = #4: nam=3D'SQL*Net=20 message to dblink' ela=3D 1 p1=3D1413697536 p2=3D1 p3=3D0
WAIT #4: = nam=3D'SQL*Net=20 message from dblink' ela=3D 2465 p1=3D1413697536 p2=3D1 p3=3D0
WAIT = #4: nam=3D'SQL*Net=20 message to dblink' ela=3D 1 p1=3D1413697536 p2=3D1 p3=3D0
WAIT #4: = nam=3D'SQL*Net=20 message from dblink' ela=3D 335 p1=3D1413697536 p2=3D1 p3=3D0
WAIT = #4: nam=3D'SQL*Net=20 message to dblink' ela=3D 0 p1=3D1413697536 p2=3D1 p3=3D0
WAIT #4: = nam=3D'SQL*Net=20 message from dblink' ela=3D 767 p1=3D1413697536 p2=3D1=20 p3=3D0


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D
PARSE ERROR #4:len=3D618 dep=3D1 uid=3D168=20 oct=3D3 lid=3D168 tim=3D951620661502 err=3D2051
SELECT A.TOKEN_TYPE, = B.COLOR,=20 C.LOCATION_NAME, C.HSBC_ENTITY, E.TOKEN_STATUS_DESC CURRENT_STATUS,=20 H.STATUS_CHANGE_DATE IN_ST
OCK_DATE, E.TOKEN_STATUS_ID FROM = TOKEN_INVENTORY=20 A, TOKEN_ATTRIBUTES B, TOKEN_DISTRIBUTION_LOCATIONS C, TOKEN_INFORMATION = D,
 TOKEN_STATUS E, TOKEN_INFORMATION H WHERE A.SERIAL_NUMBER = =3D :B1 AND=20 A.TOKEN_ATTRIBUTE_ID =3D B.TOKEN_ATTRIBUTE_ID AND B.HSBC_
LOCATION_ID = =3D=20 C.HSBC_LOCATION_ID AND A.SERIAL_NUMBER =3D D.SERIAL_NUMBER AND = D.CURRENTFLAG =3D 'Y'=20 AND D.TOKEN_STATUS_ID =3D E.TOK
EN_STATUS_ID AND D.APPLICATION_NAME = =3D=20 E.APPLICATION_NAME AND H.SERIAL_NUMBER =3D A.SERIAL_NUMBER AND = H.TOKEN_STATUS_ID =3D=20 30
EXEC=20 #3:c=3D10000,e=3D509899355,p=3D0,cr=3D0,cu=3D1,mis=3D0,r=3D0,dep=3D0,og=3D= 4,tim=3D951620662363
ERROR=20 #3:err=3D2051 tim=3D97445955
WAIT #3: nam=3D'SQL*Net break/reset to = client' ela=3D 3=20 p1=3D1650815232 p2=3D1 p3=3D0
WAIT #3: nam=3D'SQL*Net break/reset to = client' ela=3D 180=20 p1=3D1650815232 p2=3D0 p3=3D0
WAIT #3: nam=3D'SQL*Net message to = client' ela=3D 2=20 p1=3D1650815232 p2=3D1 p3=3D0
WAIT #3: nam=3D'SQL*Net message from = client' ela=3D 2155=20 p1=3D1650815232 p2=3D1 p3=3D0
QUERY
BEGIN=20 BIB_OTP_PKG.get_token_details('0058020234',:c1,:c2);=20 END;
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D



This = electronic message transmission is a PRIVATE communication which = contains information
which may be confidential or privileged. The = information is intended to be for the use of the individual
or = entity named above. If you are not the intended recipient, please be = aware that any disclosure,
copying, distribution or use of the = contents of this information is prohibited. Please notify the sender =
of the delivery error by replying to this message, or notify us by = telephone (877-633-2436, ext. 0),
and then delete it from your = system.

------_=_NextPart_001_01C5C3B8.C2523676-- -- http://www.freelists.org/webpage/oracle-l