Hi everyone,
I'm randomly getting the following error in my application:
HTTP Status Code: 572
ORDS was unable to make a connection to the database. This occurs when the database is overloaded.
I'm using a free-tier Oracle Autonomous Database with APEX.
Here's what I've observed:
- When the issue occurs, the user ORDS_PLSQL_GATEWAY has almost 1000 open cursors.
- Running
SHOW PARAMETER open_cursors; shows the value is set to 1000, and I cannot change it since it's a free-tier instance.
- The error happens even when only 2 users are connected to the application.
- There are no locks or active long-running sessions.
- Interestingly, the error is not
ORA-01000: maximum open cursors exceeded, but I suspect it might be cursor-related.
Has anyone experienced something similar?
Any suggestions on what I can check or how to better investigate this?
Thanks in advance!