Upgrade From 9i OPTIMIZER_MODE RULE Or CHOOSE No Longer Used In 10g And Higher: Use ALL_ROWS Or FIRST_ROWS _n (Doc ID 1270930.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.2 [Release 9.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 21-Sep-2016***

Symptoms

Upgrading to 10gR1 or higher and using the OPTIMIZER_MODE  parameter values CHOOSE or RULE you receive no error even though these values have been deprecated.

 You may find however, the following referenced in your ALERT.LOG:

...
SMCO started with pid=21, OS id=356
Wed Dec 01 11:27:36 2010
ALTER SYSTEM SET optimizer_mode='RULE' SCOPE=BOTH;
Wed Dec 01 11:31:34 2010
...


or during startup

System parameters with non-default values:
...
.... 
open_cursors = 300
optimizer_mode = "RULE"
diagnostic_dest =

 

Changes

Upgrade to 10gR1 or higher from 9i or lower.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms