Re: FW: raw traces - EXEC: c=10,000 e=40

Thanks for the clarification.

At 10:29 AM 12/3/2003, you wrote:
>Wolfgang,
>
>The OS has always provided microsecond data to the Oracle kernel (see
>the 'man gettimeofday' and 'man getrusage'). It's only in release 9 that
>the Oracle kernel stopped truncating the data at the centisecond digit
>(by doing an integer division of 10000).
>
>Oracle gets elapsed times by comparing pairs of gettimeofday() calls
>(truss to find out for yourself). The e=40us is actually accurate to
>within +/-1us (not counting measurement intrusion effect). The c value
>is potentially way off, as I explained in the other note.
>
>
>Cary Millsap
>Hotsos Enterprises, Ltd.
>http://www.hotsos.com

Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wolfgang Breitling
  INET: breitliw_at_centrexcc.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).