Performance Tuning Guide

Back Next

Database Target Optimization

You can optimize the target database by checking the storage clause, space allocation, and rollback or undo segments.

Consider the following solutions to reduce database target bottlenecks:

Verify that the database stores rollback or undo segments in appropriate tablespaces, preferably on different disks.: When you write to the database, the database uses rollback or undo segments during loads. Ask the database administrator to ensure that the database stores rollback or undo segments in appropriate tablespaces, preferably on different disks. The rollback or undo segments should also have appropriate storage clauses.
Tune the database redo log.: To optimize the database, tune the database redo log. The database uses the redo log to log loading operations. Make sure the redo log size and buffer size are optimal. For an Oracle database, you can view redo log properties in the init.ora file.
Connect to an Oracle database with the IPC protocol.: If the Data Integration Service runs on a single node and the Oracle instance is local to the service process node, you can optimize performance by using IPC protocol to connect to the Oracle database. You can set up Oracle database connection in listener.ora and tnsnames.ora.