Re: Strange Elapsed In Raw Trace

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Wed, 13 Oct 2004 18:56:09 -0600
Message-Id: <6.1.2.0.2.20041013185400.02409468@pop.centrexcc.com>

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,dep=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,dep=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

Received on Wed Oct 13 2004 - 19:53:38 CDT