Trace Levels

SQL_TRACE is event 10046 level 1.

Other trace levels are:

Level Description Version
1 Trace includes SQL statement, response time, service time, execution statistics (#rows, #LIOs #PRs #PWs). In 10.2 and below execution plan written to trace file when associated cursor is closed. In 11.1 and above execution plan written to trace file after first execution of each cursor - Equivalent to PLAN_STAT = 'first_execution' All
4 As level 1 plus bind variables All
8 As level 1 plus wait times All
16 As level 1 plus execution plans for every execution. Equivalant to PLAN_STAT = 'all_executions' 11.1 and above
32 As level 1 without any execution plans. Equivalent to PLAN_STAT = 'never' 11.1 and above
32 As level 1 plus execution plans for any statement execution requiring more than 60 seconds of DB time 11.2.0.2 and above

See Metalink Note 39817.1 for details of trace output