Home > IT Answers > Oracle > 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
MaxonIT1159
5 pts.
 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
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.?

Software/Hardware used:
ASKED: March 24, 2009  4:06 PM
UPDATED: March 25, 2009  2:29 AM
RELATED QUESTIONS
Answer Wiki:
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> -----------------------------------
Last Wiki Answer Submitted:  March 25, 2009  2:29 am  by  carlosdl   63,535 pts.
All Answer Wiki Contributors:  carlosdl   63,535 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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.

Djeepp
 340 pts.