Re: bind variables and child cursors
- From: fmhabash <fmhabash@xxxxxxxxx>
- To: oracledbaquestions@xxxxxxxxx
- Date: Thu, 26 Jan 2012 11:15:59 -0500
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
