How to set Open_Cursors ?

Answer > Execute the following statement after connecting to your Oracle DB.

select max(a.value) as highest_open_cur, p.value as max_open_cur
  from v$sesstat a, v$statname b, v$parameter p
  where a.statistic# = b.statistic#
  and b.name = 'opened cursors current'
  and p.name= 'open_cursors'
  group by p.value;

The value of 'max_open_cur' will be the value for Open_Cursors.