Enumeration detection errors for large databases

[jmdedalus]

Whilst attempting to import a schema from large Oracle DB (with approx. 2k tables & 20k columns), if Enumeration Detection is enabled, the MDM engine (or rather, the DatabaseDataModelImporterProviderService) soon starts reporting ORA-01000: maximum open cursors exceeded errors:

...
2023-09-06 16:41:00.533  WARN --- [pool-3-thread-1] DatabaseDataModelImporterProviderService : Could not perform enumeration or summary metadata detection on XXX.XXXXXX because of ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
ORA-01000: maximum open cursors exceeded

2023-09-06 16:41:00.614  WARN --- [pool-3-thread-1] DatabaseDataModelImporterProviderService : Could not perform enumeration or summary metadata detection on XXX.XXXXXX because of ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
ORA-01000: maximum open cursors exceeded

2023-09-06 16:41:00.693  WARN --- [pool-3-thread-1] DatabaseDataModelImporterProviderService : Could not perform enumeration or summary metadata detection on XXX.XXXXXX because of ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
ORA-01000: maximum open cursors exceeded

2023-09-06 16:41:00.694 DEBUG --- [pool-3-thread-1] DatabaseDataModelImporterProviderService : Finished enumeration and summary metadata detection in 3 mins 21 secs 992 ms
2023-09-06 16:41:00.791 ERROR --- [pool-3-thread-1] DatabaseDataModelImporterProviderService : Something went wrong executing statement while importing XXX: ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
ORA-01000: maximum open cursors exceeded