ragh..._at_gmail.com wrote:
> Hi,
> Could you please guide us as to what should be the key points to
> keep in mind when testing an application that has been migrated to
> Oracle 9i platform?
In my opinion there are numerous points to consider:
- Does the application return the same results from the 8i installation
as it does from the 9i installation? If not, why not?
- Did the performance change in an adverse manner after migration?
It's possible changes in the optimiser may affect existing queries in a
negative way. Also, code which fixed bugs in 8i may have introduced
new bugs in 9i directly affecting your application (you don't say which
releases of each you're using -- a more helpful and complete response
could be provided with such information).
- Does the application continue to run? This may appear to be a
'stupid question', however new versions of shared libraries/dlls may
result in an application which no longer runs, and a recompile may not
fix the issue as some library routines may now require additional
parameters for a successful call, and some library routines may have
been replaced by different routines, offering more functionality and
obsoleting old calls.
- Did execution paths change, even though performance apparently did
not degrade? Can these changes adversely affect the application at
some point in the future?
- If this is not an 'in-place' migration, did the data import correctly
into the 9i instance? If not, why not? Charactersets may change if
one does not pay careful attention to such details.
At the moment I cannot think of any additional items to watch, however
I'm fairly certain there are more with which to be concerned. And, I'm
fairly certain someone will add to this list, because mistakes with
such a migration can be quite costly.
David Fitzjarrell
Received on Wed Mar 23 2005 - 09:21:48 CST
