Finding Execution time of query using SQL Developer.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Tue, 16 May 2017 12:23:41 +0300
changeset 2136 3f34a66e6a2a
parent 2135 3b94fc89d75a
child 2137 81d0f561a4a3
Finding Execution time of query using SQL Developer.
oracle.rst
--- a/oracle.rst	Sun May 14 22:01:50 2017 +0300
+++ b/oracle.rst	Tue May 16 12:23:41 2017 +0300
@@ -227,11 +227,21 @@
   select ......
   exec dbms_output.put_line( (dbms_utility.get_time-:n)/100) || ' seconds....' );
 
+In SQL Developer you get execution time in result window. By default SQL
+Developer limit output to 50 rows. To run full query select result window nat
+press ``Ctrl+End``.
+
+Alternatively you may wrap you query with (and optionally use hint to disable
+optimizations??)::
+
+  select (*) from ( ... ORIGINAL QUERY ... );
+
 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://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.
 
 Last table modification time.
 =============================