12

I know I can use set timing on to see how long it took to execute a query after the execution is finished.

But is it possible to see current execution duration in Oracle SQL Developer while the query is still running?

SQL Server Management Studio as well as old Query Analyzer have such a feature:

enter image description here

13

On recent versions you can see a timer in the "Task Progress" view (View->Task Progress). Annoyingly it resets to zero the moment the task finishes! :

progress

5
  • In German versions it is called Fortschritt - Task
    – bernd_k
    May 6 '11 at 7:34
  • 1
    @bernd - doesn't that mean 'tractor' :) May 6 '11 at 7:37
  • On my machine (4.0.2.15, build 15.21) it doesn't reset, but it DOES freeze up, and often. It's been stuck at 00:32 for the past few minutes, now. Surely there's some other more robust way to get elapsed time? Dec 15 '14 at 18:37
  • @JonofAllTrades I'm using 4.0.0.3 and mine still resets. I'm unlikely to upgrade because for every issue that gets fixed I get bitten by a new one. Dec 15 '14 at 19:32
  • 1
    I can see the elapsed time of completed queries in the Statements window. Nov 6 '15 at 16:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.