Session_Cached_cursors

Hi all,

I am checking this parameter for trying to get the ideal value.

I run the script from metalink (ID 208857.1) and my results are:

PARAMETER                               VALUE                USAGE
----------------------                --------------------          -----
session_cached_cursors             20                       100%
open_cursors                              3000                       3%

Too, the following script:

SELECT cach.value cache_hits, prs.value all_parses,round((cach.value/prs.value)*100,2) as "% found in cache"
FROM  v$sesstat cach, v$sesstat prs, v$statname nm1, v$statname nm2
WHERE cach.statistic# = nm1.statistic#
AND   nm1.name = 'session cursor cache hits'
AND   prs.statistic#=nm2.statistic#
AND   nm2.name= 'parse count (total)'
AND   cach.sid= &sid and prs.sid= cach.sid