Q
Manage Learn to apply best practices and optimize your operations.

Impact of upgrade for developer

Our DBAs are planning to upgrade our Oracle 8.1.7 database to Oracle 10g. As a developer, what are the things that I should be aware of or work on? What will be the impact to the Business Object, Ab Initio and Websphere/JDBC?

Our DBAs are planning to upgrade our Oracle 8.1.7 database to Oracle 10g. As a developer, what are the things that I should be aware of or work on? What will be the impact to the Business Object, Ab Initio and Websphere/JDBC?
As a developer, you should participate in the testing process from beginning to end. The database upgrade process should be repeated several times in a non-production environment, and you will need to test all your applications supported by the databases each time.

The Oracle optimizer has undergone some major enhancements between Oracle 8.1.7 and 10g, so you may see some changes...

with respect to how some application SQL executes. Some SQL statements in your applications may run faster, and some may run slower. You should take this opportunity to monitor reports, jobs, etc. that use customized SQL and explain them in the 10g database environment. Optimize them in the non-production environment using production data so that you will be prepared when the upgrade to 10g occurs in the production environment.

Statistics collection in the database has also changed significantly between Oracle8i and 10g. This affects the optimizer which may change SQL execution paths. Review the Oracle Database 10g Release 2 New Features Guide for further information.

This was last published in July 2006

Dig Deeper on Oracle and SQL

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close