There are various ways to enable trace.
1. alter session set sql_trace = true; require DBA privileage
2. alter session set events ‘10046 trace name context forever, level 8′;
3. oradebug setmypid;
4. execute dbms_session.session_trace_enable(waits default true, binds default false); can be invoked by any user to enable session-level [...]
