diff -r 3b94fc89d75a -r 3f34a66e6a2a 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. =============================