Yes, turning time_statistics off (at the session level) gets rid of all the times() calls. Further turning off timed_os_statistics (from 5 to 0) gets rid of getrusage() as well, leaving only gettimeofday() calls
Thanks, Boris Dali. --- Boris Dali <[EMAIL PROTECTED]> wrote: > Date: Wed, 03 Dec 2003 10:29:24 -0800 > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > From: Boris Dali <[EMAIL PROTECTED]> > Subject: RE: raw traces - EXEC: c=10,000 e=40 > > 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). ______________________________________________________________________ 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).