Re: sesion_cached_cursors

In article <60801260.0107121251.15df9487_at_posting.google.com>, mtd_doherty_at_yahoo.com says...
>
>does anybody know of a good value to set sesion_cached_cursors = ?
>current value set at 100 and still have very high miss% and parses.
>Do not want to frag sga
>
>Thanks Mike

The session_cached_cursors won't affect the parse count -- it'll still "soft" parse but it'll be a much softer parse.

see
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:865497961356

a good value? depends on your application. If you use static sql in PLSQL for most everything -- you don't need it.

If you have some poorly written apps that constantly open and close the same exact statement over and over -- you need it set high.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp