Hi,
DB version: Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.15.0.0.0
When running a complex query the screen returns: ORA-01000 maximum open cursors exceeded... This message does not show up at each execution and the results are returned.
We are not sure where to investigate the problem.
Our current settings:
NAME TYPE VALUE
---------------------- ------- -----
open_cursors integer 10000
session_cached_cursors integer 50
Any ideas greatly appreciated.