Oracle set timing on drop table tab1;create table tab1(col1 int); declarebegin for i in 1..1000000 loop insert into tab1 values(i); commit; end loop;end;/ select sum(bytes) from user_segments where segment_name = 'TAB1'; alter table tab1 a…