Re: session_cached_cursors

This was really helpful thanks,

-Stan

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:<1017392903.1752.1.nnrp-10.9e984b29_at_news.demon.co.uk>...
> open_cursors and session_cached_cursors
> don't really have anything to do with each other,
> although the cursors kept "open" by caching do
> (I think) get counted under the open_cursors
> limit.
>
> There are a couple of statistics in v$sesstat
> that will help:
> session cursor cache count - how many are cached
> session cursor cache hit - how much use caching has been.
>
> If the COUNT is less than the init.ora parameter,
> then there is no point in increasing the parameter.
>
> The possible overhead is a small overhead on
> memory for the session, and a small overhead
> in CPU scanning cache (which I believe is little
> more than a set of objects holding hash values
> and pointers into the SGA). However, if the
> value is set too high, it is possible that you will
> find the SGA is being used more aggressively
> by all the extra SQL cursors that are being
> held as open.
>
>
>
>
> --
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> Next Seminar - UK, April 3rd - 5th
> http://www.jlcomp.demon.co.uk/seminar.html
>
> Host to The Co-Operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
> Author of:
> Practical Oracle 8i: Building Efficient Databases
>
>
> Stan wrote in message <3CA40547.7090106_at_yahoo.com>...
> >hi all,
> >
> >solaris 8.0, 8.1.7.2 32b
> >
> >Will there be any performance issues of increasing
> >session_cached_cursors ? already i have open_cursors set to 1000. Also
> >is there anyway i can find the optimal value for my session cached
> >cursor based on my application usuage.
> >
> >Thanks in Advance,
> >-Stan
> >
Received on Fri Mar 29 2002 - 17:00:27 CST