Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Application Performance
Thank you very much guys.
Ivan.
"Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message
news:8uxz8.93224$HH5.5630_at_rwcrnsc51.ops.asp.att.net...
> Stephan is correct. But you can eliminate the soft parses by not closing
> the cursor. More like
> if first time ever for this query (upon startup)
> open cursor
> end if
> bind variables
> execute and fetch
>
> Jim
>
> "Stephan Bressler" <stephan.bressler_at_pdb.sbs.de> wrote in message
> news:aalkjh$g8g$1_at_news.mch.sbs.de...
> > Hi,
> >
> > starting with 8i there's a distiction in v$sysstat in 'parses' and 'hard
> > parses'. 'parse' occure every time a new statement is parse, even if it
is
> > already in the sql-area. 'hard parse' occur for every new statement.
> >
> > So TOADs rule seems to be old fashioned. Rely on v$sysstat('parses',
> > 'parses(hard)' and 'execute count')
> >
> > Regards
> > Stephan
> >
> >
>
>
Received on Tue Apr 30 2002 - 09:32:56 CDT