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. 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
set timing on
, SQL*Plus prints the elapsed time for each statement it submits to the database.