I have found my max number of cursors per database to be 300 from the following query:

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;

I tried to update the amount to 1000 with this:

  update v_$parameter
  set value = 1000
  where name = 'open_cursors';

But I am seeing this error:

SQL Error: ORA-02030: can only select from fixed tables/views
02030. 00000 -  "can only select from fixed tables/views"
*Cause:    An attempt is being made to perform an operation other than
           a retrieval from a fixed table/view.
*Action:   You may only select rows from fixed tables/views.

What is the proper way to update the open_cursor value? Thanks.

Edit
Report