Oracle database maximum open cursors threshold oracle-database-maximum-open-cursors-threshold
CAUTION
AEM 6.4 has reached the end of extended support and this documentation is no longer updated. For further details, see our technical support periods. Find the supported versions here.
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.
recommendation-more-help
a6ebf046-2b8b-4543-bd46-42a0d77792da