Take the 2-minute tour ×
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. It's 100% free, no registration required.

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

1 Answer 1

up vote 5 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! :

progress

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 (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? –  Jon of All Trades Dec 15 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. –  Jack Douglas Dec 15 at 19:32

Your Answer

 
discard

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.