Margie wrote:
> If I run tkprof and I get the output, e.g.,
>
> SELECT Name
> FROM USER.USER_view
> where "PHONE"=:1 AND Name LIKE :2 AND ("Date" is NULL OR "Date" >=
> :3)
>
> Can I get actual values instead of :1 :2 and :3? I would like to
> re-run the query to see how it performs instead of tracing it.
>
> Thanks, Margie
I don't recall the exact syntax off the top of my head,
but you get to see the bind variables by setting
event 10046 to a value of 12.
Received on Fri Apr 16 2004 - 19:19:39 CDT
