Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle Linux timing

Oracle Linux timing

From: Anton Dischner <dischner_at_klch.med.uni-muenchen.de>
Date: Mon, 18 Dec 2000 10:04:24 +0100
Message-ID: <181220001004244543%dischner@klch.med.uni-muenchen.de>

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/dischner
Received on Mon Dec 18 2000 - 03:04:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US