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).