How to check query time in PL/SQL?
I have some update statements in my pl/sql procedure that I want to
keep check
of the timing every time I execute it. I notice that I can't
use 'start/stop
timing' in pl/sql like I do in sqlplus. Is there any other way
to check the
query time in pl/sql?
Ans:
start_time := dbms_utility.get_time;
update ...
elapsed_time := dbms_utility.get_time - start_time;
(hundredths of a second)