Search notes:

Oracle: Init parameter OPTIMIZER_MODE

The value of optimizer_mode can be set to

first_rows or first_rows_n, where n is 1, 10, 100 or 1000
all_rows (the default)

See also

The first_rows hint.

init parameters