Multiple choice technology

How can you test whether the target writer is causing bootleneck?

  1. Configure a session to write to a file

  2. Configure a session to write to a oracle database

  3. Configure a session to write to a table without indexes but constraints enabled.

  4. Configure a session to write to a table without indexes but constraints disabled.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Writing to a file is faster than writing to a database and eliminates database-related bottlenecks. If performance improves with file output, the target writer was the bottleneck. Writing to Oracle, tables with/without indexes, or constraints doesn't isolate the writer bottleneck as cleanly as a file target.

Keep practicing — related questions