Oracle9i desupport date set for July 2015

Oracle has 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 optimal migration.

Feel free to call BC at 800-766-1884 to speak with a 10g migration consultant.  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 data.
 

Just call BC to get support from a 10g migration expert to ensure a smooth an optimal Oracle10g migration.