Why session cursor cache count is over the session_cached_cursors parameter?
SYS@DB>select * from (select t.value ,s.sid, s.sql_id from v$sesstat t, v$statname n, v$session s where t.sid=s.sid and n.name= 'session cursor cache count' and t.statistic# = n.statistic# order by 1 desc) where rownum <=10; 2 3 4 VALUE SID SQL_ID ---------- ---------- ------------- 3313121 3037 10744 2630 2380 1562 1846 2874 1843 827 1838 1234 1822 168 970 578 315 826 157 823 10 rows selected. SYS@DB>SYS@DB>SYS@DB>SYS@DB>show parameter cursor NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ cursor_bind_capture_destination string memory+disk cursor_sharing string EXACT cursor_space_for_time boolean FALSE open_cursors integer 400 session_cached_cursors integer 50 SYS@DB>