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 JANUARY 08, 2025
Applies to:
Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.2 [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"
diagnostic_dest =
Changes
Upgrade to 10gR1 or higher from 9i or lower.
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |