Re: Times do not add up in 10046 trace file

"hpuxrac" <johnbhurley_at_sbcglobal.net> wrote:
> mccmx_at_hotmail.com wrote:
> > Oracle 10.2.0.2 W2K3
> >
> > In the summary section of the trace file below, the total elapsed time
> > is 113.84s of which 72.12s seconds was CPU time. This leaves 41s of
> > wait time. However the wait breakdown adds up to much more than this.
> > Ignoring SQL*Net wait times because they are 'between call' waits, we
> > have at least, 63.15 + 33.10 + 3.91 = 100.16.
> >
> > Can anyone explain why the total wait time is so much higher than the
> > difference between CPU and elapsed times....?
> >
> > ***********************************************************************
> > *********
> >
> > OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS
> >
> > call count cpu elapsed disk query current
> > rows
> > ------- ------ -------- ---------- ---------- ---------- ----------
> > ----------
> > Parse 10675 8.39 12.22 0 3 0
> > 0
> > Execute 57732 36.50 57.10 100129 101923 165840
> > 27507
> > Fetch 53336 27.23 44.51 101400 1213121 0
> > 53250
> > ------- ------ -------- ---------- ---------- ---------- ----------
> > ----------
> > total 121743 72.12 113.84 201529 1315047 165840
> > 80757

Where does the "elapsed" time spend waiting on commit get reported? Is it in the "Execute"? I would look into the actual 10046 trace file, rather than the summary, to try to figure this out.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB