Define "refresh dials".
If you don't "refresh dials", does the application still crash?
refresh Dials means: Chart Type Dial, in Attributes "Automatic Refresh" yes, interval 10 seconds. That's it.
Without refreshing no new cursors are opened and therefore no crash.
But we need the refresh because it's a monitoring system.
opened a SR and here is the answer.
It's a bug in ORDS.
Bug 25214859 - ORA-01000 CAUSED BY POSSIBLE CURSOR LEAK WITH ORDS.
Will be fixed in ORDS 3.0.9. No release date available at this time.
Kind Regards, Alfred