This discussion is archived
2 Replies Latest reply: Nov 6, 2012 8:45 PM by LaserSoft RSS

DB upgrade fom 9i to 10gR2

user503988 Newbie
Currently Being Moderated
Do we need to know if failover and loadbalancing is implemented to plan for DB upgrade from 9i to 10gR2? If so why?
  • 1. Re: DB upgrade fom 9i to 10gR2
    549846 Newbie
    Currently Being Moderated
    check for the same
  • 2. Re: DB upgrade fom 9i to 10gR2
    LaserSoft Journeyer
    Currently Being Moderated

    Issues when upgrading from Oracle 9i :

    1. Hash Group by aggregation which allows a hash algorithm to process group by statements. You have to use for sorts ORDER BY.
    2. 10g CBO has been added costed subquery unnesting and view merging functionality.
    a. Symptoms might range from high parse times to wrong results
    3.The CONNECT Role has been changed since 10g R2
    4. Parse times may increase after upgrade/migration

    Hope it helps....



  • Correct Answers - 10 points
  • Helpful Answers - 5 points