Re: Viewing bind variable values in 10g - Any suggestions?

And if you don't need wait stats, set level 4 instead. See eg http://www.psoug.org/reference/trace_tkprof.html

2008/11/6 Stefan Knecht <knecht.stefan_at_gmail.com>

> There's several ways:
>
> - you can turn on auditing with db_extended. That will capture the bind
> values (along with the sql statement in aud$ table)
> - you can use 10046 trace at level 12 (to get wait + bind info in the
> tracefile)
>
> Stefan
>
>
> On Thu, Nov 6, 2008 at 10:58 AM, Teijo Lallukka <teijo.lallukka_at_edita.fi>wrote:
>
>> Hi list members!
>>
>> Do you know way to view bind variables which are used in insert/update
>> statement?
>>
>> I know that in 10g there is a view v$sql_bind_capture but it is very
>> limited and only usefull when bind is in where or having clause. And also
>> there is bug in timestamp datatype which will be fixed 11.2, I think.
>>
>> I would be thankfull for all ideas how to get binds from db without
>> touching application to get trace or debug info...
>>
>> -Teijo L.
>> Oracle DBA
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>
>
> --
> =========================
>
> Stefan P Knecht
> Senior Consultant
> Systems Engineering
>
> OPITZ CONSULTING Schweiz GmbH
> Seestrasse 97
> CH-8800 Thalwil
>
> Mobile +41-79-571 36 27
> stefan.knecht_at_opitz-consulting.ch
> http://www.opitz-consulting.ch
>
> OCP 9i/10g SCSA SCNA
> =========================
>

--
http://www.freelists.org/webpage/oracle-l