In the database oracle in the company where I work i have a problem with the session_cached_cursors, in the addm repport they recomend to increase the value that already is 750 and the default value is 50
when it's made this query:
SELECT a.value curr_cached, p.value max_cached,
s.username, s.inst_id, s.sid, s.serial#
FROM gv$sesstat a, gv$statname b, gv$session s, gv$parameter2 p
WHERE a.statistic# = b.statistic# and s.sid=a.sid and s.inst_id = a.inst_id --and a.sid=&sid
AND p.name='session_cached_cursors'
AND b.name = 'session cursor cache count'
order by a.value desc;
it responds with this values
the value of max cache cursors are 750 and the values of the current cached cursors are way beyond the limit
what is recomended ? to increase the value, how much I need to increase ?