December 2002
Intermediate to advanced
928 pages
85h 29m
English
OPTIMIZER_PERCENT_PARALLEL
Value: 0-100
Default: 0
Dynamic: ALTER SESSION
Specifies the amount of parallelism that the optimizer uses in its cost functions. Default means that the optimizer chooses the best serial plan. A value of 100 means that the optimizer uses each object’s degree of parallelism in computing the cost of a full table scan operation. Obsolete with Oracle9i.