How To Find Query Execution Time in Oracle SQL Developer?

Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.

December 26, 2023
SQL Developer
1 min read

You have executed a query in Oracle SQL Developer, and now you want to view the execution time for that SQL query. Below is a tip to how to find query execution time in Oracle SQL Developer.

Find Query Execution Time in Oracle SQL Developer

Before running the query in Oracle SQL Developer, open the SQL History panel window by one of the following ways:

Click on the menu View > SQL History.
Press F8 Key.

Now run your SQL query, and you will be able to find the query execution time in Duration column of SQL history window in Oracle SQL Developer, as shown in below image. By default, SQL History shows the result in descending order, but if not you can view the result in descending order by clicking on the Timestamp column header.