Multiple choice technology enterprise content management

Which Oracle Enterprise stage read property can be set using db options to tune job performance?

  1. memsize

  2. arraysize

  3. partitionsize

  4. transactsize
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In Oracle Enterprise Datastage stages, the arraysize property controls how many rows are fetched in each batch from the database. A larger arraysize reduces network round-trips and improves performance. Options A, C, and D are not valid Oracle read performance tuning properties available through db options.

AI explanation

In the Oracle Enterprise stage, the arraysize database option controls how many rows are fetched or inserted per round-trip to the database, and tuning this batch size is a standard way to improve throughput and job performance.

Keep practicing — related questions