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 APRIL 06, 2022
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 9.2 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document