Table of Contents

Search

  1. Abstract
  2. Supported Versions
  3. Tuning and Sizing Guidelines for Data Engineering Integration (10.4.x)

Tuning and Sizing Guidelines for Data Engineering Integration (10.4.x)

Tuning and Sizing Guidelines for Data Engineering Integration (10.4.x)

Tune the Oracle Database

Tune the Oracle Database

To optimize the performance of Oracle databases, perform the following tasks:
  • Analyze database statistics to fine tune queries.
  • Maintain different physical disks for different tablespaces.
  • Determine the expected database growth.
  • Use the EXPLAIN PLAN statement to fine tune queries.
  • Avoid foreign key constraints.
  • Drop indexes before loading data.
  • Set open cursors and sessions optimally for mappers to process queries in parallel.

0 COMMENTS

We’d like to hear from you!