RE: Strange Elapsed In Raw Trace
- From: "Larry Elkins" <elkinsl@xxxxxxxxx>
- To: <breitliw@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 13 Oct 2004 20:28:53 -0500
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@xxxxxxxxx
214.954.1781
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Wolfgang Breitling
> Sent: Wednesday, October 13, 2004 7:56 PM
> To: oracle-l@xxxxxxxxxxxxx
> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
