No problem! PL/SQL provides a mechanism to obtain timings of code execution that are accurate to 100th of a second: the DBMS_UTILTY.GET_TIME function.
Within PL/SQL you can use DBMS_UTILITY.GET_TIME that provides a mechanism to obtain timings of code execution that are accurate to 100th of a second.
Check it before and after the section you want to find out the time taken and check the difference.
In SQL*Plus you can also try to use SET TIMING ON.
No comments:
Post a Comment
Os comentários são moderados.
The comments are moderated.