Oracle and PL/SQL
Timing Queries and Scripts in PL/SQL
Motivation
Logging is an essential feature in any software, be it during development or after release to production. One feature that I found lacking in Oracle PL/SQL is a portable, built-in facility to help developers track execution times of blocks of code/SQL.
I found that SQL*PLUS has some built-in functions that provide support for timing queries and… »















































