The gettimeofday() function obtains the current time, expressed as seconds and microseconds since 00:00 Coordinated Universal Time (UTC), January 1, 1970, and stores it in the timeval structure pointed to by tp. The resolution of the system clock is unspecified.
The getrusage() function provides measures of the resources used by the current process or its terminated and waited-for child processes. If the value of the who argument is RUSAGE_SELF, information is returned about resources used by the current process. If the value of the who argument is RUSAGE_CHILDREN, information is returned about resources used by the terminated and waited-for children of the current process. If the child is never waited for (for instance, if the parent has SA_NOCLDWAIT set or sets SIGCHLD to SIG_IGN), the resource information for the child process is discarded and not included in the resource information provided by getrusage(). The r_usage argument is a pointer to an object of type struct rusage in which the returned information is stored times() fills the structure pointed to by buffer with time-accounting information. The structure defined in <sys/times.h> is as follows: struct tms { clock_t tms_utime; /* user time */ clock_t tms_stime; /* system time */" clock_t tms_cutime; /* user time, children */ clock_t tms_cstime; /* system time, children */ }; This information comes from the calling process and each of its terminated child processes for which it has executed a wait(), These are from HPUX 11.11. In HPUX and all other unix execute man <your command or system call> to get more information. Allan -----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). ______________________________________________________________________________ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan 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).