You can find dbms_monitor package very useful for this task DBMS_MONITOR.SESSION_TRACE_ENABLE( session_id IN BINARY_INTEGER DEFAULT NULL, serial_num IN BINARY_INTEGER DEFAULT NULL, waits IN BOOLEAN DEFAULT TRUE, binds IN BOOLEAN DEFAULT FALSE) Michael On Thu, Nov 6, 2008 at 11:58 AM, Teijo Lallukka <teijo.lallukka@xxxxxxxx>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 > > -- > //www.freelists.org/webpage/oracle-l > > > -- Best Regards Michael Elkin