Search notes:

SQL*Plus: SET TIMING

With timing on, SQL*Plus prints the elapsed time for each statement it encounters.

set timinig on

create table abc …

insert into abc select …

update abc …

set timing off

See also