Re: Bind variable - missing/00 legth value

  • From: Egor Starostin <egorst@xxxxxxxxx>
  • To: cichomitiko@xxxxxxxxx
  • Date: Wed, 24 Aug 2005 08:06:13 +0700

> 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.

Free Oracle Session Resource Profiler

Other related posts: