Index >
ORACLE Server Parameters >
_optimizer_degree
_optimizer_degree
NOTE: This is an internal Oracle parameter. Do NOT use it unless instructed
to do so by Oracle Support. Playing with this parameter may be harmful.
Oracle 11.1.0:
Parameter Name: | _optimizer_degree
| Description: | force the optimizer to use the same degree of parallelism
| Type: | NUMBER
| Obsoleted: | FALSE
| Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | IMMEDIATE
|
Oracle 10.2.0:
Parameter Name: | _optimizer_degree
| Description: | force the optimizer to use the same degree of parallelism
| Type: | NUMBER
| Obsoleted: | FALSE
| Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | IMMEDIATE
|
Oracle 10.1.0:
Parameter Name: | _optimizer_degree
| Description: | force the optimizer to use the same degree of parallelism
| Type: | NUMBER
| Obsoleted: | FALSE
| Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | IMMEDIATE
|
Oracle 9.2.0:
Parameter Name: | _optimizer_degree
| Description: | force the optimizer to use the same degree of parallelism
| Type: | NUMBER
| Obsoleted: | FALSE
| Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | FALSE
|
Oracle 8.1.7:
Parameter Name: | _optimizer_degree
| Description: | force the optimizer to use the same degree of parallelism
| Type: | NUMBER
| Obsoleted: | FALSE
| Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | FALSE
|
Oracle 8.0.6:
No such parmeter in Oracle 8.0.6.
Oracle 7.3.4:
No such parmeter in Oracle 7.3.4.
This parameter is not documented and should not be used.
Search for more info about
[ _optimizer_degree ]
on the Oracle FAQ.
|