Re: bind variables and child cursors

  • From: "Rich Jesse" <rjoralist2@xxxxxxxxxxxxxxxxxxxxx>
  • To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 26 Jan 2012 09:37:15 -0600 (CST)

> 1. is it possible to get the bind variable from a query, if you start the
> trace after the query has started? I have been using 10046 trace. Any other
> traces that might get this?

Maybe not exactly what you're looking for, but V$SQL_BIND_CAPTURE may have
the *last* bind variables used.

It's probably worth a look anyway.  I use it extensively to troubleshoot
bind/skew issues in v10.1.

GL!

Rich

--
//www.freelists.org/webpage/oracle-l


Other related posts: