Re: Bind variable - missing/00 legth value

> 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? 
It means that NULL is passed as value.
Btw, my profiler (link in signature) can display values of bind
variables so you don't need to dig in raw trace file.


-- 
Egor
http://www.oracledba.ru/orasrp/
Free Oracle Session Resource Profiler
--
http://www.freelists.org/webpage/oracle-l

Other related posts: