Does the bulkArraySize internal parameter apply to CDC or just Full Load?

[MoeE]

Hi,

I have 2 questions hopefully you can help with.

1. I'd like to know if the bulkArraySize internal parameter is applicable to CDC as we are trying to maximise a client's performance during periods in which the source database experiences high volumes of changes. I've seen articles like this one. However, it looks like it only mentions that it is for Full Load and not for CDC.

2. My second question is can we enable "Copy redo logs to a temporary folder" and increase the number of concurrent ASM read threads at the same time? Is it redundant to do both at the same time?

For context, this Qlik Community article mentions that enabling the setting "Copy redo logs to a temporary folder" on the Oracle source endpoint should increase performance. Can I stack these over one another to increase performance?

Help with this is appreciated. Thank you.

Kind regards,

Mohammed

[john_wang]

Hello Mohammed, @MoeE 

1. I'd like to know if the bulkArraySize internal parameter is applicable to CDC

---

No. The bulkArraySize parameter only impacts Full Load processing and does not affect CDC.

---

2. My second question is can we enable "Copy redo logs to a temporary folder" and increase the number of concurrent ASM read threads at the same time

---

No. The concurrent ASM read threads are used specifically for reading REDO logs from ASM. Once the REDO logs are copied to the temporary folder, they become regular OS files and are no longer managed or accessed through ASM. Therefore, increasing the concurrent ASM read threads does not apply to the copied REDO log files.

Hope this helps.

John.