Saturday, November 14, 2015

8:20 AM

It old question but i have found easy way to measure time of running a script in sqlplus. You just have to add this on the beginning

timing starttiming_name

And this on the end of a script

timing stop

More information about this command can be found at Oracle's SQL*Plus® User's Guide and Reference: Collecting Timing Statistics

Inserted from <http://stackoverflow.com/questions/8401270/get-execution-time-of-sql-script-in-oracle-sqlplus>