Getting bind variables from a sql trace

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.

yea you have to set sql_trace at level 4

Code:

---

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

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

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 :D

Thanks guys.
what does the 10046 represent?

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