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.
Any suggestions?