| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Oracle Linux timing
Hi,
in SQLPLUS you can 'set timing on' and you get elapsed time of every command.
On
Oracle 8.1.6, Suse 7.0 SMP 2.2.16 on a dual Pentium and a Oracle 8.1.6, Suse 6.4 SMP 2.2.14 on a dual Pentium and Oracle 8.1.7, Suse 7.0 single Pentium 2.2.16
the given time is 1.66 times higher than the real elapsed time.
Runs OK on
Oracle 7.3.3 on Irix 6.2
Oracle 7.3.3 on AIX 3.2.5
Anybody sees this on Linux too?
Any ideas?
regards,
Toni
PS: What i did:
sqlplus
set timing on
create table ttt as select * from <any_table>;
insert into ttt select * from ttt;
insert into ttt select * from ttt;
insert into ttt select * from ttt;
... as long as you want to measure every time comparing
... elapsed time with hand stopped time.
-- Q: How did the medical community come up with the term "PMS"? A: "Mad Cow Disease" was already taken. Posen fuer Anfaenger: http://www.w-klch.med.uni-muenchen.de/dischnerReceived on Mon Dec 18 2000 - 03:04:24 CST
![]() |
![]() |