RE: tkprof output

Thanks so much fo rthe info

Qs1 How does Execute <-> Count ( 335531 ) compare with & Execute <-> rows ( 1903902 ) figure

      & their respective meaning / significance ?

> -----Original Message-----
> From: Kelly Goodrich - FGM [SMTP:kelly.goodrich_at_lmco.com]
> Sent: Thursday, May 18, 2000 10:13 PM
> To: Pisarchuk, Landon
> Cc: oracledba_at_quickdoc.co.uk
> Subject: Re: tkprof output
>
> Parse - is when the sql statement is checked for syntax, valid object and
> in which an
> execution plan is determined by the
> optimizer.
>
> Execute is when a sql statement is executed or in the case of a query,
> prepared for
> fetching.
> Fetch in which rows are returned from a query.
> Your statistics show that this query executed 335531 times.
>
> To find the expense of your query, take blocks read (query + current) and
> divide by rows.
> 796437+0/2239432.
>
> You should parse once and execute several times (which you do)
>
> To determine if the application is using arrays (take rows fetched to
> count fetch)
>
> "Pisarchuk, Landon" wrote:
>
> > Ok, this is a bit of a silly question but I want to ask it to confirm my
> > suspicions anyway.
> > Looking at the following tkprof output, how many times was the query
> run?
> >
> > call count cpu elapsed disk query current
> rows
> > ------- ------ -------- ---------- ------- --------
> > ---------- ----------
> > Parse 1 0.00 0.00 0 0 0
> > 0
> > Execute 335531 39.02 30.56 0 0 0
> 1903902
> > Fetch 335530 54.09 44.30 0 796437 0
> 335530
> > ------- ------ -------- ---------- ------- ----------
> > ---------- ----------
> > total 671062 93.11 74.86 0 796437 0
> 2239432
> >
> > I think it is once because it is only parsed once but that the hell is
> the
> > execute and fetch counts?
> >
> > Landon Pisarchuk
> > ISL, Database Administrator
> > 780.427.9416 ext.263
> >
> > --------
> > If you're bored, then visit the list's website: http://www.lazydba.com
> (updated daily)
> > to unsubscribe, send a blank email to
> oracledba-unsubscribe_at_quickdoc.co.uk
> > to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
>
> --
> Kelly Goodrich
> Sr. Database Engineer
> FGM Inc.
>
>
>
> --------
> If you're bored, then visit the list's website: http://www.lazydba.com
> (updated daily)
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
Received on Fri May 19 2000 - 00:45:42 CDT