Re: bind variables and child cursors
From: fmhabash <fmhabash_at_gmail.com>
Date: Thu, 26 Jan 2012 11:15:59 -0500
Message-ID: <4F217C3F.80704_at_gmail.com>
is it possible to get the bind variable from a query, if you start the trace after the query has started? I'm not aware of any method to peek at a bind value for a running query other than using extended trace. Once parsed, you can see it through ...
Date: Thu, 26 Jan 2012 11:15:59 -0500
Message-ID: <4F217C3F.80704_at_gmail.com>
is it possible to get the bind variable from a query, if you start the trace after the query has started? I'm not aware of any method to peek at a bind value for a running query other than using extended trace. Once parsed, you can see it through ...
- This can be seen through ... 1) select * from table (dbms_xplan.display_cursor('....',363,'PEEKED_BINDS')) 2) v$sql_bind_capture: as mentioned by previous reply. 3) DBA_HIST_SQLBIND: historically. 4) SQLTXPLAIN: extremely revealing.
When I look in v$session, I can get the current sql_id. How do I find out which child cursor that session is using? child_number column
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 26 2012 - 10:15:59 CST