Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to find current value of bind variables

Re: How to find current value of bind variables

From: Egor Starostin <egorst_at_gmail.com>
Date: Fri, 2 Sep 2005 09:56:55 +0700
Message-ID: <f0fc9197050901195649fe36b1@mail.gmail.com>


> I know how to find bind variable values with a trace, but that requires you
> to start a trace prior to the parsing of the query and it's too late for
Prior to the executing of the query, to be exact (although, it's almost the same when query executed only once). But if the query executed many times with different bind values, then after enabling of extended sql trace somewhere in the middle of executions you will see subsequent bind values.

-- 
Egor
http://www.oracledba.ru/orasrp/
Free Oracle Session Resource Profiler
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 01 2005 - 21:58:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US