• Basic Materialized Views
  Using MV_CAPABILITIES_TABLE. DDL to create it for explaining feature availability, explain plan for materialized view
  in Oracle > DB 11g with explain mv_capabilities_table plan
• Oracle DBMS_XPLAN Explain Plan
  PSOUG explain plan options practices with sqlid
  in Oracle with dbms_xplan explain options package plan sqlid
• 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
• Oracle DBMS_SQLTUNE ADDM Grid
  Access information on SQL Tuning Tasks previously executed
  in Oracle > Optimization with advisor explain oracle plans recommendations sql sta tuning

explain from all users