Re: Application Performance

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:02:44 CDT