Oracle database maximum open cursors threshold oracle-database-maximum-open-cursors-threshold

To configure a maximum value for open cursors in Oracle, you may have to tune this value to a number that is appropriate to your application. It is evident that under a moderate load, the average cursors open was 2700. It is recommended that you start with an upper limit of 3000. For more information, go to https://www.orafaq.com/node/758.