How to check sql query execution time in sql developer

Posted on

Question :

I need to check any sql Statment exact execution time (how much time it will take to complete that sql Statment without running this query) in Oracle sql developer tools without running that sql Statment

Answer :

Getting exact execution time without actual execution, that just won’t happen. The database is called Oracle, but it isn’t able to predict the future.

But you can check the estimated execution time. This is a feature of the database, not SQL Developer. Use explain plan for on your query, such as:

explain plan for select * from dual;

Then

select * from table(dbms_xplan.display);

Result:

Plan hash value: 272002086

--------------------------------------------------------------------------
| Id  | Operation         | Name | Rows  | Bytes | Cost (%CPU)| Time     |
--------------------------------------------------------------------------
|   0 | SELECT STATEMENT  |      |     1 |     2 |     2   (0)| 00:00:01 |
|   1 |  TABLE ACCESS FULL| DUAL |     1 |     2 |     2   (0)| 00:00:01 |
--------------------------------------------------------------------------

The estimated time is in the Time column.

If you want to get query execution time using Oracle sql developer tools. SQL developer is having option to provide the same.

Select the query statement and use F10 to get the estimated execution plan, please note that would be estimated only, not the actual plan.

Leave a Reply

Your email address will not be published. Required fields are marked *