http://netvouz.com/MondoTofu/tag/explain?feed=rss MondoTofu's bookmarks tagged "explain" on Netvouz http://docs.oracle.com/cd/B28359_01/server.111/b28313/basicmv.htm#sthref245 Using MV_CAPABILITIES_TABLE. DDL to create it for explaining feature availability, explain plan for materialized view Oracle > DB 11g MondoTofu Thu, 04 Apr 2013 19:11:27 GMT http://psoug.org/reference/dbms_xplan.html PSOUG explain plan options practices with sqlid Oracle MondoTofu Thu, 10 Apr 2014 02:06:14 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 http://psoug.org/reference/dbms_sqltune.html Access information on SQL Tuning Tasks previously executed Oracle > Optimization MondoTofu Thu, 10 Apr 2014 13:51:13 GMT