Re: Bind variable - missing/00 legth value
- From: Jared Still <jkstill@xxxxxxxxx>
- To: cichomitiko@xxxxxxxxx
- Date: Wed, 24 Aug 2005 01:15:34 -0700
Oracle Version?
10g perhaps?
On 8/23/05, Radoulov, Dimitre <cichomitiko@xxxxxxxxx> wrote:
>
> During a tuning session I've noticed that the bind variable value was
> missing in the trace file (10046, level 12) and the avl(Actual value
> length (array length too)) is 00. Does anybody know what this means?
>
...
> FETCH #23:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=813439885
> BINDS #23:
> bind 0: dty=2 mxl=22(21) mal=00 scl=00 pre=00 oacflg=03 oacfl2=1 size=24
> offset=0
> bfp=01a51c28 bln=22 avl=00 flg=05
> EXEC #23:c=0,e=0,p=0,cr=2,cu=0,mis=0,r=0,dep=1,og=4,tim=813439885
> FETCH #23:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=813439885
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
