Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query Execution time

user483578Jul 24 2019 — edited Jul 24 2019

Hi All,

i want to find out a time taken to insert a simple insert to a table.

I wrote a pl/sql block by putting systimestamp at the begining and to the end to see the time durarion.

This give a difference about 2.12 milliseconds but in Toad bottom screen it

shows 325 miliseconds (mesec) to get the insert executed.

Can anyone explain me why it shows different time gaps from systimestamp and toad?

Comments
Post Details
Added on Jul 24 2019
5 comments
2,992 views