Search notes:

SQL*Plus: TIMING

With timing, it's possible to have SQL*Plus measure the time for multiple statements and then print the elapsed time. This is in contrast to set timing on which prints the elapsed time for each encountered statement.
Multiple concurrent timers can be started and SQL*Plus automatically nests them. 
timing start "Installation"

timing start "Create schema"
@create-schema.sql
timing stop

timing start "Fill tables"
@fill-tables.sql
timing stop

timing start "Run analysis"
@run-analysis
timing stop

timing stop

See also

After set timing on, SQL*Plus prints the elapsed time for each statement it submits to the database.
There is no timing command in SQLcl, use set timing instead.

Index