Trace Levels

Oracle Internals

Trace

SQL_TRACE is event 10046 level 1

Other trace levels are

Level	Description
0	Disabled
1	Same as ALTER SESSION SET sql_trace = TRUE
4	Include bind information
8	Include event wait statistics
12	Include bind information and event wait statistics

See Metalink Note 39817.1 for details of trace output