# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1494926738 -10800
# Node ID 81d0f561a4a3132b2b4c49484e8daa03e80f5cc8
# Parent  3f34a66e6a2a09dca6c801aa4804116aa39a6f1e
explain plan.

diff -r 3f34a66e6a2a -r 81d0f561a4a3 oracle.rst
--- a/oracle.rst	Tue May 16 12:23:41 2017 +0300
+++ b/oracle.rst	Tue May 16 12:25:38 2017 +0300
@@ -236,12 +236,22 @@
 
   select (*) from ( ... ORIGINAL QUERY ... );
 
+Another option is::
+
+  delete plan_table;
+  explain plan for ... SQL statement ...;
+  select time from plan_table where id = 0;
+
 See:
 
 http://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2113.htm
   $SQL lists statistics on shared SQL area without the GROUP BY clause.
 http://stackoverflow.com/questions/22198853/finding-execution-time-of-query-using-sql-developer
   Finding Execution time of query using SQL Developer.
+http://stackoverflow.com/questions/3559189/oracle-query-execution-time
+  Oracle query execution time.
+http://tkyte.blogspot.com/2007/04/when-explanation-doesn-sound-quite.html
+   When the explanation doesn't sound quite right...
 
 Last table modification time.
 =============================