Re: 9i Parsing Optimization

Hi Bernard

session_cached_cursors has same value in 8i and 9i, 100.

TIA On 8/31/06, Polarski, Bernard <Bernard.Polarski_at_atosorigin.com> wrote:
>
> In the upgrade process, did you changed 'session_cached_cursors' from 0
> (default in 8i) to something like 50+?
> In this case your hits are much better and there is less pression on the
> shared pool, hence your parsing decrease also.
>
> ------------------------------
> *From:* Allen, Brandon [mailto:Brandon.Allen_at_OneNeck.com]
> optimizer_max_permutations would only reduce the time spent on parsing,
> not the number of parses. In the original post, the parse "count" was
> reduced from 120 to 60. Seems to me like maybe it was some sort of pl/sql
> optimization that kept the cursor open so it didn't have to be reparsed?
>
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Anjo Kolk
> Without seeing the statement, I would say max_permutations.
>
> Privileged/Confidential Information may be contained in this message or
> attachments hereto. Please advise immediately if you or your employer do not
> consent to Internet email for messages of this kind. Opinions, conclusions
> and other information in this message that do not relate to the official
> business of this company shall be understood as neither given nor endorsed
> by it.
>

--
http://www.freelists.org/webpage/oracle-l