| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: raw traces - EXEC: c=10,000 e=40
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()
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.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boris Dali INET: boris_dali_at_yahoo.ca 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: ListGuru_at_fatcity.com (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: anelson_at_midf.com 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: ListGuru_at_fatcity.com (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).Received on Wed Dec 03 2003 - 12:59:25 CST
 |
 |