Re: session_cached_cursors pros & cons

Mark,

I did that but I don't see how it guides me to the size of the shared pool. For example, I ran it against a test db and got the following results:

PARAMETER                     VALUE USAGE
----------------------------- ----- -----
session_cached_cursors          100   35%
open_cursors                    255   15%

2 rows selected.

CURSOR_CACHE_HITS SOFT_PARSES HARD_PARSES

----------------- ----------- -----------
            92.17%       6.69%       1.14%

1 row selected.

MAX_CACHEABLE_CURSORS

                   186

1 row selected.

It looks like my session_cached_cursors is too high according to the above but how do I determine the increase to the SP from this?

Joe

Bobak, Mark wrote:

> Joe,
> Go to:
> http://www.ixora.com.au/scripts/library.htm
> and look for the session_cursor_cache.sql script.
>

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