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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).