Re: Viewing bind variable values in 10g - Any suggestions?
Date: Fri, 7 Nov 2008 10:29:55 -0800
Message-ID: <bf46380811071029j370bcaf8t3a1ea4b1d006896d@mail.gmail.com>
You may want to consider the OraSRP for use with trace files.
Works fairly well, and is free.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
On Thu, Nov 6, 2008 at 1: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
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 07 2008 - 12:29:55 CST