Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question
up vote 7 down vote accepted

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! :


share|improve this answer
In German versions it is called Fortschritt - Task – bernd_k May 6 '11 at 7:34
@bernd - doesn't that mean 'tractor' :) – Jack Douglas May 6 '11 at 7:37
On my machine (, 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? – Jon of All Trades Dec 15 '14 at 18:37
@JonofAllTrades I'm using and mine still resets. I'm unlikely to upgrade because for every issue that gets fixed I get bitten by a new one. – Jack Douglas Dec 15 '14 at 19:32
I can see the elapsed time of completed queries in the Statements window. – Patrick Szalapski Nov 6 '15 at 16:54

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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