Oracle9i desupport date set for July 2015
Oracle Database Tips by Donald Burleson
announced desupport for Oracle 9i release 2 as of July 31, 2015
(see MOSC note 161818.1).
This is an important announcement for any Oracle customers who
must run on a fully-supported release of their Oracle database.
While Oracle offers a limited "extended support" plan,
Oracle9i is still desupported for any new bug fixes as of July 31, 2015. For shops that are required to run a fully-supported release of
Oracle, it's time to plan a migration to Oracle 10g release 2.
The 10g migration is straightforward, but the kernel source code has
changed in Oracle10g, leading to unplanned changes in Oracle
execution. This is largely due to changes in Oracle
defaults for SQL optimization and initialization parameters.
It is highly recommended that Oracle9i shops who migrate to
Oracle 10g consult with a 10g migration expert to ensure a smooth an
Feel free to call BC at 800-766-1884 to speak with a 10g
It's never a good idea to plan an Oracle 10g migration without
fully understanding the important changes in Oracle 10g, as many
of the changes are complex and unobtrusive.
The benefits of an upgrade to Oracle 10g are very compelling.
Oracle has completely rewritten the source code to make it far
faster, and native PL/SQL can run many times faster than
Oracle9i. Oracle 10g is also more stable and robust.
Also many DBA features are automated in Oracle 10g including
optimizer statistics collection and the new Automatic Workload
repository which captures important time-series performance
Just call BC to get support from a 10g migration expert to ensure a smooth an
optimal Oracle10g migration.
If you like Oracle tuning, see the book "Oracle
Tuning: The Definitive Reference", with 950 pages of tuning tips and
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot of Oracle tuning scripts.