AW: [suse-oracle] Performance testing 2004-07-13 - By Anton Dischner
Hi Maurice,
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;
drop table benchtest;
regards,
Toni
--
+-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- -----+
| Anton Dischner, Unix admin, Oracle-DBA Phone: +49 89 70953202|
| Institut fuer Klinische Chemie Fax : +49 89 70958888|
| Klinikum Grosshadern Home : +49 89 69708766|
| Ludwig Maximilians Universitaet Muenchen Mobil: +49 172 8388880|
| 81366 Muenchen Germany |
| Marchioninistr. 15 dischner at med.uni-muenchen.de|
+-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- -----+
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
|
|
