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
add comment

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
add comment

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.