NEED HELP to DETERMINE STEPS to TAKE when going from 9i to 10g in terms of plsql best practices as well as known issues to watchout for

5 pts.
Tags:
Oracle 10g
Oracle 9i
Oracle 9i to 10g Upgrade
PL/SQL
Need Expert Help to Determine Steps to Take: When going from 9i to 10g in terms of: _______________________________ 1) plsql best practices for both 9i and 10g that are specific and could be measured against 2) known issues to watchout for in terms of 10g overall, 10g prominent bugs/issues 3) known issues with plsql 4) known issues with stats collection and management 5) known issues with bringing over stats from 9i to a 10g db 6) known issues with bringing over large indexes built in 9i to 10g db 7) 9i to 10g conversion issues and watchouts 8) running un-updated, non-best practice wrapped 8i code in a 10g db ______________________________________________________________________ What course of action is recommended? What expert resources should be consulted, white papers,etc.?
ASKED: March 24, 2009  4:06 PM
UPDATED: March 25, 2009  2:29 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Have a look at the official <a href=”http://download.oracle.com/docs/cd/B19306_01/server.102/b14238/toc.htm”>Oracle┬« Database Upgrade Guide</a>. Section 5 covers “Compatibility and Interoperability”.

Here are some other useful links:

<a href=”http://www.dba-oracle.com/t_slow_performance_after_upgrade.htm”>Oracle 10g Migration: slow performance after upgrade to Oracle10g</a>
<a href=”http://www.dba-oracle.com/t_10g_migration_tips.htm”>Oracle speaks on 10g migration tips</a>
<a href=”http://www.dba-oracle.com/t_sql_merge_join_cartesian.htm”>Merge join cartesian tips</a>

Additionally, you might want to take a look at a recent question/discussion here on ITKE, which revealed the existence of some PL/SQL bugs: <a href=”http://itknowledgeexchange.techtarget.com/itanswers/oracle-9i-to-oracle-10g-upgrade-help-needed-for-some-plsql-errors/”>Oracle 9i to Oracle 10g Upgrade – Help needed for some PL/SQL errors</a>

———————————–

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
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
  • Djeepp
    When we brought our application over from 9i to 10g, we ran into major problems with the optimizer (we were using the RBO in 9i). Make sure to do thorough testing of all the aspects of your application before moving to production. If you are already using the CBO in 9i, you probably won't have as many issues, but statistics do become more robust and touchy as you move from one version to the other. Your question indicates that some of the code you are bringing forward was built for 8i so should keep a very close eye on that particular code when testing, especially if your sql is complicated or the tables you are joining are large. The biggest mistake we made was not load testing the server properly. Make sure you can generate production and beyond production loads when testing.
    340 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
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

Thanks! We'll email you when relevant content is added and updated.

Following