• 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
• Silent ORA-904 on MERGE « Timur Akhmadeev's blog
  Silent ORA-904 on MERGE From time to time looking at the tkprof’ed SQL traces I see this message: The following statement encountered a error during parse: SELECT 1 FROM DUAL WHERE some_predicate_here Error encountered: ORA-00904
  in Oracle > DB 11g with encountered merge message ora-00904 ora-904 tkprof trace traces
• Trace a Concurrent Request And Generate TKPROF File « Thirst for Oracle !!!
  Another example: To get (TKPROF) sorted by longest running queries first and limits the results to the “Top 10″ long running queries $ tkprof raw_trace_file.trc output_file sys=no explain=apps/ sort=’(prsela,exeela,fchela)’ print=10 Usage: tkprof
  in Oracle > Optimization with exeela explain fchela longest print prsela running tkprof usage

tkprof from all users