patternModerate
Query execution time in Oracle SQL Developer
Viewed 0 times
sqlquerytimedeveloperoracleexecution
Problem
I know I can use
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:
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.