Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to find current value of bind variables
> 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-lReceived on Thu Sep 01 2005 - 21:58:55 CDT
![]() |
![]() |