Oracle Fusion Transportation Intelligence (FTI) ETL Data Loads

Hello,

I'm very new to Oracle's Fusion Transportation Intelligence; however, I recently have been involved in getting it stood up in a production environment as a DBA.

As background, the FTI installation occured on a RHEL 6 server, and the database server it connects to runs on Solaris 10.

I noticed an ETL process which loads stage data into a target table, with an estimated rowcount of about 9.7 million rows. The load never completed, and I terminated the process when it was about 16 hours into the process. The Oracle wait events indicate that it spent a lot of time fetching data across the network to and from the database server using the configured array and batch size, along with a very large amount of redo log switches.