Oracle Scratchpad

February 19, 2007

Parallelism and CBO

Filed under: CBO, Parallel Execution, Troubleshooting — Jonathan Lewis @ 9:43 pm UTC Feb 19,2007

In the 9i Database Performance Tuning Guide and Reference part no: A96533-01, there is a convenient list of features that “require the CBO” on page 1-15, with the note

“Use of any of these features enables the CBO, even if the parameter OPTIMIZER_MODE is set to RULE.”

The list is as follows:
(more…)

Blog at WordPress.com.