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