please take this for a very basic benchmark in SQL*Plus, please share your results:
set timing on set pause off
drop table benchtest; create table benchtest ( operator varchar (39), line integer, text varchar2(2000) ) storage (initial 1M next 1M pctincrease 0); begin for i in 1..500000 loop insert into benchtest(operator, line, text) values(user, i, lpad(to_char(i), 200)); end loop; end; /
select count(*) from benchtest where operator = user order by line;
update benchtest set text = text where operator = user; commit;
delete from benchtest where operator = user; commit;
select line, text from benchtest where operator = 'abcde' order by line;
select line, text from benchtest where operator = user order by line;
-- To unsubscribe, email: suse-oracle-unsubscribe@(protected) For additional commands, email: suse-oracle-help@(protected) Please see http://www.suse.com/oracle/ before posting
