Wednesday, November 17, 2010

Trace levels

# Oracle Trace  Levels

     0 - No trace. Like switching sql_trace off.
     2 - The equivalent of regular sql_trace.
     1 (SQL_TRACE)
     4 (SQL_TRACE+BINDS)
     8 (SQL_TRACE+WAITS)
     12(SQL_TRACE+BINDS+WAITS)

Hope this helps. Regards Rupam