Re: Bind variable - missing/00 legth value
- From: Egor Starostin <egorst@xxxxxxxxx>
- To: jkstill@xxxxxxxxx
- Date: Wed, 24 Aug 2005 15:42:04 +0700
> Oracle Version?
It doesn't matter. When we pass NULL value in bind variable then
avl=00 either in 8i or 9i or 10g.
> 10g perhaps?
>
> > 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
--
Egor
http://www.oracledba.ru/orasrp/
Free Oracle Session Resource Profiler
--
//www.freelists.org/webpage/oracle-l
Other related posts:
