1. Administrator's Guide
  2. Optimizing Performance
  3. Tuning Oracle 11g Databases for Financial Management
  4. Tuning Guidelines for Oracle 11g Databases
  5. OPTIMIZER_MODE

OPTIMIZER_MODE

OPTIMIZER_MODE establishes the default behavior for choosing an optimization approach for the instance. You can set the optimizer mode to FIRST_ROWS for optimal online application response, or to ALL_ROWS to minimize total execution time for batch operations. Because Oracle Hyperion Financial Management deals only with the total returned data set, minimizing the total execution time is more appropriate.

Suggested setting: ALL_ROWS