http://netvouz.com/MondoTofu/tag/trace?feed=rss MondoTofu's bookmarks tagged "trace" 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://www.cyberciti.biz/faq/howto-use-linux-truss-strace-command/ strace good for centos GNU/Linux MondoTofu Fri, 25 Mar 2011 20:12:44 GMT