1、查看当前参数值及使用率，判断是否需要修改

select 'session_cached_cursors' parameter,

       lpad(value, 5) value,

       decode(value, 0, '  n/a', to_char(100 * used / value, '990') || '%') usage

  from (select max(s.value) used

          from v$statname n, v$sesstat s

         where n.name = 'session cursor cache count'

           and s.statistic# = n.statistic#),

       (select value from v$parameter where name = 'session_cached_cursors')

union all

select 'open_cursors',

       lpad(value, 5),

       to_char(100 * used / value, '990') || '%'

  from (select max(sum(s.value)) used

          from v$statname n, v$sesstat s

         where n.name in

               ('opened cursors current', 'session cursor cache count')

           and s.statistic# = n.statistic#

         group by s.sid),

       (select value from v$parameter where name = 'open_cursors');

2、修改参数的方法

alter system set session_cached_cursors = 100;

alter system set open_cursors = 500;