Upgrade From 9i OPTIMIZER_MODE RULE Or CHOOSE No Longer Used In 10g And Higher: Use ALL_ROWS Or FIRST_ROWS _n
Last updated on SEPTEMBER 21, 2016
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [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
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"
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