HiveBrain v1.2.0
Get Started
← Back to all entries
patternModerate

Query execution time in Oracle SQL Developer

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
sqlquerytimedeveloperoracleexecution

Problem

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:

Solution

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

Context

StackExchange Database Administrators Q#2551, answer score: 14

Revisions (0)

No revisions yet.