On Thu, 12 Jul 2007 21:28:27 +0200, "astalavista" <nobody_at_nowhere.com>
wrote:
>>
>> No, we do not need more information. The answer to his question is that
>> with 10046, level 12, bind variables will be in the trace file. This is
>> so ever since Oracle7. Unfortunately, tkprof doesn't format bind
>> variables, so he will have to read the raw trace file. The version is
>> important only if he's running Oracle 6 or lower versions.
>
>OK thanks I think I don't see bind variable
>because the query is running and
>I don't set the event before the query start
>am i right ?
>I only see wait event: db file sequential read
>
>My question was :
>is it possible to see bind variables of a running query ??
>
>Thanks
>
>
select * from dict where table_name like '%BIND%'
some people will NEVER use the tools presented to them over and over
again.
--
Sybrand Bakker
Senior Oracle DBA
Received on Thu Jul 12 2007 - 15:27:22 CDT
