Copy of Oracle FAQ ORACLE RECOVERY without DUL
ORAFAQ HOME | ORAFAQ ASK QUESTION | ORAFAQ ADD INFO | ORAFAQ SEARCH | ORAFAQ E-MAIL
 

Index > ORACLE Server Parameters > optimizer_mode

optimizer_mode

Oracle 10.0.1:

Paramter Name:optimizer_mode
Description:optimizer mode
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:TRUE Can ALTER SYSTEM:IMMEDIATE

Oracle 9.2.0:

Paramter Name:optimizer_mode
Description:optimizer mode
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:TRUE Can ALTER SYSTEM:FALSE

Oracle 8.1.7:

Paramter Name:optimizer_mode
Description:optimizer mode
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:TRUE Can ALTER SYSTEM:FALSE

Oracle 8.0.6:

Paramter Name:optimizer_mode
Description:optimizer mode
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:TRUE Can ALTER SYSTEM:FALSE

Oracle 7.3.4:

Paramter Name:optimizer_mode
Description:optimizer mode
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

Related Error Messages:

ORA-01986: OPTIMIZER_GOAL is obsolete
    Cause: An obsolete parameter, OPTIMIZER_GOAL, was referenced.

    Action: Use the OPTIMIZER_MODE parameter.

This parameter is documented in the Oracle Server Reference Guide. Search for more info about [ optimizer_mode ] on the Oracle FAQ.

ORAFAQ HOME | ORAFAQ ASK QUESTION | ORAFAQ ADD FAQ | ORAFAQ SEARCH | ORAFAQ E-MAIL
All content of this page is copy from www.orafaq.com