Getting bind variables from a sql trace

[mb]

Im using the set_sql_trace_in_session package to trace/debug an application problem. Does anyone know of a way of getting the bind variables from the trace.

[pando]

yea you have to set sql_trace at level 4

alter session set events '10046 trace name context forever, level 4'

if it´s remote session you have to use oradebug or dbms_system but I forgot the syntax for dbms_system (it´s smth dbms_system.set_ev )

PROCEDURE SET_EV
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 SI                             BINARY_INTEGER          IN
 SE                             BINARY_INTEGER          IN
 EV                             BINARY_INTEGER          IN
 LE                             BINARY_INTEGER          IN
 NM                             VARCHAR2                IN

But if it´s remote session oradebug is easier I guess

[gpsingh]

use event 10046 with level 8 or use package dbms_system.set_ev with level 8.

[pando]

I think level 8 doesnt give bind variable, it gives session waits, you can use either level 4 or 12 (level 12 is level 4+8, both bind variables and session waits)


Hmm nice holiday tomorrow here in madrid

[mb]

Thanks guys.
what does the 10046 represent?

[pando]

10046 is equivalent to SQL_TRACE, it´s just the event number