My Oracle Support Banner

Is There a Pragmatic Way of Bypassing Oracle RDBMS RAC Features to Increase ODI Performance (Doc ID 1507417.1)

Last updated on OCTOBER 13, 2023

Applies to:

Oracle Data Integrator - Version 11.1.1.5.0 and later
Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.

Goal

Currently, we are attempting to do a one-off massive load of data to an Oracle RDBMS RAC configuration in a parallel manner using multiple, simultaneously running ODI Scenarios. These parallel Scenarios do not populate the same tables so no runtime collision is possible.

Due to the massive dataset size and although the servers have a considerable performance, we are observing insufficient performance and the dataloads are running for too long.

Our current considerations lead us to believe that if we could selectively distribute ODI Scenaro runs to specific Oracle RDBMS instances - rather than running all Scenarios to a single Oracle RAC database connection (implemented as a single Oracle technology Data Server in ODI Physical Archtecture) then this would allow us to bypass RAC artefacts and thus increase performance.

Is this possible and if so how to set up this configuration ?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.