Re: Viewing bind variable values in 10g - Any suggestions?
Date: Fri, 7 Nov 2008 21:18:11 +0200
You can find dbms_monitor package very useful for this task
session_id IN BINARY_INTEGER DEFAULT NULL, serial_num IN BINARY_INTEGER DEFAULT NULL,
waits IN BOOLEAN DEFAULT TRUE, binds IN BOOLEAN DEFAULT FALSE)
On Thu, Nov 6, 2008 at 11: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
> 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
-- Best Regards Michael Elkin -- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 07 2008 - 13:18:11 CST