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

If you have a developer who is interested in this surely you could use this opportunity to point out the advantages of code instrumentation. After all it's their code that is responsible for binding the values in the first place - if the code gets instrumented then he'd only need to enable his instrumentation for the activity of interest. 10046 and auditing are an alternative to instrumenting your code properly in the first place after all.

only partly in jest

On Thu, Nov 6, 2008 at 11:40 AM, Teijo Lallukka <teijo.lallukka_at_edita.fi>wrote:

> Hi!
>
> Thanks for replies but...
>
> trace with level 4 is good way for me but developer face went green for
> too much work of digging dump... ;-)
>
> Do you have handy example how to get SQL + Binds from audit tables with one
> SQL_id ... ? or atleast which audit view those bind are going and how to
> query those nice way...
>
> -Teijo L.
>
> >>> "Stefan Knecht" <knecht.stefan_at_gmail.com> 6.11.2008 12:35:26 >>>
> 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
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

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