You're on the right trail by experimenting with it. I'm surprised that the number of gettimeofday() calls is so small. The times() call is the SVR4 analog of the BSD getrusage() call. I guess I shouldn't be surprised to see both times() and getrusage() being used.
Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta - SQL Optimization 101: 12/8 Dallas, 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -----Original Message----- Boris Dali Sent: Wednesday, December 03, 2003 12:29 PM To: Multiple recipients of list ORACLE-L Is this true? strace-ing on linux shows gettimeofday calls (for e) and getrusage (for c) - just like Cary describes. On HP however tusc-ing a simple "select * from dual" issued from sqlplus I see: calls sys call ----- -------- 1 gettimeofday() 1 getrusage() 15 times() Which sys call is used for what? Guess I can turn timed_statistics off and see how it affects the (amount of) sys calls issued Thanks, Boris Dali. --- Niall Litchfield <[EMAIL PROTECTED]> wrote: > <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). ______________________________________________________________________ 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: Cary Millsap 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).