Re: Oracle Linux timing

From: Peter J. Holzer <hjp-usenet_at_SiKitu.wsr.ac.at>
Date: Mon, 18 Dec 2000 22:25:40 +0100
Message-ID: <slrn93t06k.1pj.hjp-usenet@teal.h.hjp.at>

On Mon, 18 Dec 2000 10:04:24 +0100, Anton Dischner wrote:
>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.

Sound suspiciously as if sqlplus uses times(2) to get the elapsed time and then divides the clock ticks by 60 instead of 100.

-- 
   _  | Peter J. Holzer    | Es war nicht Gegenstand der Abstimmung zu
|_|_) | Sysadmin WSR       | Punkt 1b), die Anordnung der natürlichen 
| |   | hjp_at_wsr.ac.at      | Zahlen neu festzulegen.
__/   | http://www.hjp.at/ |	-- Johannes Schwenke <jby@ginko.de>

Received on Mon Dec 18 2000 - 15:25:40 CST