oracle.rst
changeset 2137 81d0f561a4a3
parent 2136 3f34a66e6a2a
child 2146 274a3e6678ba
--- 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.
 =============================