bind variables and child cursors

From: Dba DBA <oracledbaquestions_at_gmail.com>
Date: Thu, 26 Jan 2012 10:29:40 -0500
Message-ID: <CAE-dsOJ-XZT15AV_qKJ424LXS4Y9KeL8iqTLmrQeZ6tCW1hnSw_at_mail.gmail.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?
  2. 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?
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 26 2012 - 09:29:40 CST

Original text of this message