In the init.ora of my database, max_open_cursors is set to 500.
Is there a cost in memory or performance if I bump it to 2000?
Idle sessions have open cursors that never close. This seems like an application problem that would be better solved by fixing the code rather than increasing the max number of open cursors.
I would agree. If you could change code rather than increasing open_cursors parameter I would do it. 500 is already large enough value.
You can use dbms_session.set_close_cached_open_cursors to close the open cursors in oracle8i .
Or you can kill those idle sessions and it will get removed from