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 <boris_dali_at_yahoo.ca> wrote: > Date:
Wed, 03 Dec 2003 10:29:24 -0800
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> From: Boris Dali <boris_dali_at_yahoo.ca>
> 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
> <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).
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).
Received on Wed Dec 03 2003 - 12:59:32 CST
