equal
deleted
inserted
replaced
225 variable n number |
225 variable n number |
226 exec :n := dbms_utility.get_time; |
226 exec :n := dbms_utility.get_time; |
227 select ...... |
227 select ...... |
228 exec dbms_output.put_line( (dbms_utility.get_time-:n)/100) || ' seconds....' ); |
228 exec dbms_output.put_line( (dbms_utility.get_time-:n)/100) || ' seconds....' ); |
229 |
229 |
|
230 In SQL Developer you get execution time in result window. By default SQL |
|
231 Developer limit output to 50 rows. To run full query select result window nat |
|
232 press ``Ctrl+End``. |
|
233 |
|
234 Alternatively you may wrap you query with (and optionally use hint to disable |
|
235 optimizations??):: |
|
236 |
|
237 select (*) from ( ... ORIGINAL QUERY ... ); |
|
238 |
230 See: |
239 See: |
231 |
240 |
232 http://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2113.htm |
241 http://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2113.htm |
233 $SQL lists statistics on shared SQL area without the GROUP BY |
242 $SQL lists statistics on shared SQL area without the GROUP BY clause. |
234 clause. |
243 http://stackoverflow.com/questions/22198853/finding-execution-time-of-query-using-sql-developer |
|
244 Finding Execution time of query using SQL Developer. |
235 |
245 |
236 Last table modification time. |
246 Last table modification time. |
237 ============================= |
247 ============================= |
238 :: |
248 :: |
239 |
249 |