Multiple choice technology databases

Array Size is mainly used to increase the buffer during Write operations into a Oracle DB in a Server job using the Oracle OCI stage.

  1. True

  2. False

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In DataStage Oracle OCI stage, the Array Size property controls the number of rows written in each batch to the database. Increasing this value reduces network round trips between DataStage and Oracle by buffering more rows before sending them, which significantly improves write performance for bulk operations. This is a performance tuning technique specifically for write operations, not reads.