• ORACLE-BASE - SQL trace, 10046, trcsess and tkprof in Oracle
  SQL trace, 10046, trcsess and tkprof in Oracle The quickest way to capture the SQL being processed by a session is to switch on SQL trace or set the 10046 event for a representative period of time. The resulting trace files can be read in their raw state or translated using the tkprof utility. Trace files are found in v$diag_info view
  in Oracle > Optimization with 10046 capture event file files oracle sql time tkprof trace trc user utility v$diag_info

v$diag_info from all users