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