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
<niall.litchfield_at_dial.pipex.com> 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: ml-errors_at_fatcity.com
> [mailto:ml-errors_at_fatcity.com] 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: ml-errors_at_fatcity.com
> [mailto:ml-errors_at_fatcity.com] 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: 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).
> > >
> >
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> > --
> > Author: Niall Litchfield
> > INET: niall.litchfield_at_dial.pipex.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).
> >
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Niall Litchfield
> INET: niall.litchfield_at_dial.pipex.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).
Post your free ad now!
http://personals.yahoo.ca
--
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Cary Millsap
INET: cary.millsap_at_hotsos.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 - 13:04:25 CST
