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 to [Release 9.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 21-Sep-2016***


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
Wed Dec 01 11:31:34 2010

or during startup

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



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


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