Oracle CDC to JDBC max open cursors exceeded

asked 2020-09-29 15:17:14 -0500

KateF gravatar image

updated 2020-09-29 15:18:13 -0500

Hi, I have a pipeline:

  • Oracle CDC Origin (reading from Oracle 18c db)
  • Expression Evaluator adds two fields
  • JDBC Destination (updating Oracle 18c db)

Data is flowing properly but the performance could be better. So initially we decided to change the setting on the origin - Max Batch Size (records) - from 100 which was the default there, to 1000, which is documented as the default.

When we do that we are consistently getting Max open cursors exceeded error on the destination. So we thought maybe increasing the Maximum Pool Size on the destination would help, we changed that from 1 to 10. That did not seem to make a difference.

The open cursors per session setting on the destination Oracle 18c database is 300. Is there any advice about either why it's causing the max open cursors error or how to improve the throughput?

Thanks!

edit retag flag offensive close merge delete