From oracle-l-bounce@freelists.org Wed Aug 24 03:17:43 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j7O8Hhhe011762 for ; Wed, 24 Aug 2005 03:17:43 -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 j7O8HVIP011738 for ; Wed, 24 Aug 2005 03:17:31 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2E6E91E6749; Wed, 24 Aug 2005 03:17:27 -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 30214-05; Wed, 24 Aug 2005 03:17:27 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9B7D11E6768; Wed, 24 Aug 2005 03:17:26 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=Sjn0IhAJy59V+QO8v5/qsNY7yAhz5fcGe6h/jgvenIcehYxX0LYkqO81aQW4x5vCPYQCbGQ6zxSy37cJJLNyTIdvdS4KbSr7ao3pvQaZXIYoLtlKuEzagZS/CcBlcve9OGuLIglatvbx45dubu87lqu5bA/gS/8AZyB5hbMI4oY= Message-ID: Date: Wed, 24 Aug 2005 01:15:34 -0700 From: Jared Still To: cichomitiko@gmail.com Subject: Re: Bind variable - missing/00 legth value Cc: oracle-l@freelists.org In-Reply-To: <010501c5a81f$402c3a20$4500a8c0@IBME1D11967173> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_169_23534560.1124871334886" References: <010501c5a81f$402c3a20$4500a8c0@IBME1D11967173> X-archive-position: 24401 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jkstill@gmail.com Precedence: normal Reply-To: jkstill@gmail.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.3 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_Part_169_23534560.1124871334886 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Oracle Version? 10g perhaps? On 8/23/05, Radoulov, Dimitre wrote: >=20 > During a tuning session I've noticed that the bind variable value was=20 > missing in the trace file (10046, level 12) and the avl(Actual value=20 > length (array length too)) is 00. Does anybody know what this means? > =20 ... > FETCH #23:c=3D0,e=3D0,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,ti= m=3D813439885 > BINDS #23: > bind 0: dty=3D2 mxl=3D22(21) mal=3D00 scl=3D00 pre=3D00 oacflg=3D03 oacfl= 2=3D1 size=3D24=20 > offset=3D0 > bfp=3D01a51c28 bln=3D22 avl=3D00 flg=3D05 > EXEC #23:c=3D0,e=3D0,p=3D0,cr=3D2,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim= =3D813439885 > FETCH #23:c=3D0,e=3D0,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,ti= m=3D813439885 > =20 --=20 Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist ------=_Part_169_23534560.1124871334886 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Oracle Version?

10g perhaps?

On 8/23/05, Radoulov, Dimitre <cichomitiko@gmail.com> wrote:
During a tuning session I've noticed t= hat the bind=20 variable value was missing in the trace file (10046, level 12) an= d the=20 avl(Actua= l value length (array=20 length too)) is 00.  Does anybody know what this=20 means?
 
...
FETCH=20 #23:c=3D0,e=3D0,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D8134= 39885
BINDS=20 #23:
 bind 0: dty=3D2 mxl=3D22(21) mal=3D00 scl=3D00 pre=3D00 oacfl= g=3D03 oacfl2=3D1=20 size=3D24 offset=3D0
   bfp=3D01a51c28 bln=3D22 avl=3D00 flg= =3D05
EXEC=20 #23:c=3D0,e=3D0,p=3D0,cr=3D2,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D8134= 39885
FETCH=20 #23:c=3D0,e=3D0,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D8134= 39885
 
 


--
Jared S= till
Certifiable Oracle DBA and Part Time Perl Evangelist

------=_Part_169_23534560.1124871334886-- -- http://www.freelists.org/webpage/oracle-l