Re: soft parses of recursive (system) statements

From: Anna C. Dent <anacedent_at_hotmail.com>
Date: Fri, 19 Sep 2003 17:50:10 -0700
Message-ID: <6vNab.142$Ms2.94@fed1read03>

NetComrade wrote:

> We've been fighting soft parses for the past 3-4 weeks (during high
> load we execute up to 4000 queries per second)
> So far we got the 'parse to execute' ration down to ~15% from about
> 40%.
> Whenever I look at trace files of sessions, sorted by prscnt, i see
> that the majority (well, lots) of internal statements are 'recursive'
> and always softparsed.
> Is there are anything I can do to reduce soft parses?
> Is there are anything I can do to reduce recursive calls?
>

Reduce the use of synonyms & views Received on Fri Sep 19 2003 - 19:50:10 CDT