1) If all tasks are run concurrently, the replication job will indeed be executed in parallel. However, this approach has some disadvantages:
i) The same redo log will be read three times, resulting in a total of 150 GB being read (50 GB * 3).
ii) The three tasks will interfere with each other, potentially causing performance degradation.
2) in Oracle Database, you can manage the priority of sessions and users through Resource Manager. Resource Manager allows you to allocate CPU, parallel execution resources, and other system resources differently based on user accounts, sessions, or other criteria. This can be useful in scenarios like yours, where you want to give one account (e.g., "A") higher priority over another account (e.g., "B") when they execute similar queries. And you can use different accounts in your Qlik Replicate tasks.
I hope this helps.
John.
Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
in Such Situations you must use Logstream Steup were only one ( logstream task read from Source database) and configure 3 replicate tasks to read the changes from staging folder.
where you can tweak replicate task settings to by allocating mor resources to configured target.
