<me> reads Jonathan's description and blushes</me> So it'll be a *feature* and not a bug then. IIRC e comes from POSIX gettimeofday calls on all platforms except Windows -- where it looks like GetTickCount. If this is true then the accuracy of e will be limited by the accuracy of gettimeofday.
Niall > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Niall Litchfield > Sent: 02 December 2003 22:24 > To: Multiple recipients of list ORACLE-L > Subject: RE: raw traces - EXEC: c=10,000 e=40 > > > I'd be highly, highly suspicious of the cpu time c. > > 1. You should be able to verify (roughly the elapsed time) of > the statement, if by no other means than running in sqlplus > with timing on. > 2. 3 statements with *exactly* the same cpu time - all in > very very round numbers. Seems unlikely to me. > > Might be an hp-ux bug but as I don't have HP-UX to play with > that is speculation of the first order. > > Niall > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > > Behalf Of Boris Dali > > Sent: 02 December 2003 20:49 > > To: Multiple recipients of list ORACLE-L > > Subject: raw traces - EXEC: c=10,000 e=40 > > > > > > Reading Cary's book I understand that c and e are > > measured via different system calls (haven't truss'ed > > [well tusc'ed] them yet - I am on HP-UX 11.11), but > > would anybody know what the reasonable upper limit of > > c-e might be? > > > > I am looking at the trace file where c is more than > > two orders of magnitude greater than e, which make me > > wonder if I a have some anomaly on my system > > > > Some examples: > > > > EXEC > > > #98:c=10000,e=433,p=0,cr=2,cu=2,mis=0,r=1,dep=1,og=4,tim=1777312113968 > > > > EXEC > > #110:c=10000,e=390,p=0,cr=1,cu=3,mis=0,r=1,dep=1,og=4,tim=1777 > > 312181650 > > > > PARSE > > > #103:c=10000,e=40,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1777314524922 > > > > Oracle 9.2.0.4.0 on HP-UX 11.11 > > > > Thanks, > > Boris Dali. > > > > ______________________________________________________________ > > ________ > > Post your free ad now! http://personals.yahoo.ca > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Boris Dali > > 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). > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Niall Litchfield > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield 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).