http://netvouz.com/MondoTofu/tag/tkprof?feed=rss MondoTofu's bookmarks tagged "tkprof" on Netvouz http://www.oracle-base.com/articles/misc/sql-trace-10046-trcsess-and-tkprof.php 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 Oracle > Optimization MondoTofu Thu, 28 Aug 2014 13:59:45 GMT http://timurakhmadeev.wordpress.com/2010/02/15/silent-ora-904-on-merge/ 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 Oracle > DB 11g MondoTofu Thu, 28 Aug 2014 15:24:08 GMT http://fshaikh.wordpress.com/2011/01/09/trace-a-concurrent-request-and-generate-tkprof-file/ 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 Oracle > Optimization MondoTofu Wed, 10 Sep 2014 02:37:18 GMT