explain plan.
--- 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.
=============================