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