Re: bind variables and child cursors
From: Rich Jesse <rjoralist2_at_society.servebeer.com>
Date: Thu, 26 Jan 2012 09:37:15 -0600 (CST)
Message-ID: <01996b0db53c92a00fc59d566bf4f88e.squirrel_at_society.servebeer.com>
> 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?
Date: Thu, 26 Jan 2012 09:37:15 -0600 (CST)
Message-ID: <01996b0db53c92a00fc59d566bf4f88e.squirrel_at_society.servebeer.com>
> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 26 2012 - 09:37:15 CST