Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Strange Elapsed In Raw Trace

RE: Strange Elapsed In Raw Trace

From: Larry Elkins <elkinsl_at_flash.net>
Date: Wed, 13 Oct 2004 20:28:53 -0500
Message-ID: <MPBBKDBLJAGDLMINJNKBCELKDBAB.elkinsl@flash.net>


No complaints ;-) They were happy with the *improvement*, or rather the user's ancestors were ;-)

An interesting thing is as the tracing continued I saw tim "wrap" back around:

EXEC
#5:c=27796875,e=807813015,p=89100,cr=262523,cu=44854,mis=0,r=33244,dep=1,og= 4,tim=18446744073387654595
*** 2004-10-13 17:34:19.679
EXEC
#5:c=27250000,e=471891123,p=98010,cr=262880,cu=34213,mis=0,r=29151,dep=1,og= 4,tim=471891123
*** 2004-10-13 17:45:43.523

I've been metalink'ing and google'ing (web sites and usenet) for more information about "tim" and it's derivation but haven't come up with anything yet. But I'm sure there's a rational explanation for this. Just trying to understand what it is. I've seen this before. And I've worked in DEC/VAX, MS-DOS (with Oracle 5), AIX, HP-UX, Solaris, and Windows environments. And I know for a fact that I've seen this before in this current Windows environment. Just trying to remember if I've seen it in other environments.

Regards,

Larry G. Elkins
elkinsl_at_flash.net
214.954.1781

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Wolfgang Breitling
> Sent: Wednesday, October 13, 2004 7:56 PM
> To: oracle-l_at_freelists.org
> Subject: Re: Strange Elapsed In Raw Trace
>
>
> If I calculated that correctly, the 3rd exec took 584,942.4 years. Did
> anyone complain about performance?
>
> At 06:12 PM 10/13/2004, Larry Elkins wrote:
> >PARSE #5:c=0,e=3328,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=3401329811
> >*** 2004-10-13 16:06:45.632
> >EXEC
> >#5:c=4562500,e=207030037,p=11799,cr=36578,cu=6669,mis=0,r=15004,d
> ep=1,og=4,t
> >im=3608386193
> >*** 2004-10-13 16:12:35.476
> >EXEC
> >#5:c=6484375,e=349792572,p=22658,cr=90642,cu=3842,mis=0,r=15801,d
> ep=1,og=4,t
> >im=3958240955
> >*** 2004-10-13 16:21:02.632
> >EXEC
> >#5:c=9546875,e=18446744065825247453,p=32226,cr=92572,cu=15058,mis
> =0,r=14816,
> >dep=1,og=4,tim=18446744069784377492
> >*** 2004-10-13 16:26:53.070
>
> Wolfgang Breitling
> Oracle7, 8, 8i, 9i OCP DBA
> Centrex Consulting Corporation
> http://www.centrexcc.com
>
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 13 2004 - 20:19:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US