Home » SQL & PL/SQL » SQL & PL/SQL » Performance Degrade when ported from 9i to 10g (Oracle 9i to Oracle 10g)
icon9.gif  Performance Degrade when ported from 9i to 10g [message #311177] Thu, 03 April 2008 11:29 Go to next message
swathis
Messages: 2
Registered: April 2008
Junior Member
We have just ported from 9i to 10g (don't even know if 'ported is the right word') Confused . Unfortunately all the batch commands that ran well and efficiently then are going awry now! Can anyone give any pointers why this could be happening?

What are the main differences between 9i and 10g?

Any help is much appreciated!

Re: Performance Degrade when ported from 9i to 10g [message #311178 is a reply to message #311177] Thu, 03 April 2008 11:33 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>What are the main differences between 9i and 10g?
Too many to list and may even be mostly unrelated to what you are concerned about.
How exactly did you "port"?
Did you atleast collect the statistics after porting?
Re: Performance Degrade when ported from 9i to 10g [message #311185 is a reply to message #311178] Thu, 03 April 2008 11:45 Go to previous messageGo to next message
swathis
Messages: 2
Registered: April 2008
Junior Member
Many Thanks for your time and reply Mahesh Rajendran. However there are still many things.....

>>What are the main differences between 9i and 10g?
Too many to list and may even be mostly unrelated to what you are concerned about.
>> Could you maybe list a few? Or give me a pointer where I can get some info?

How exactly did you "port"?
>> Is Upgrade a better word then? Well, I didnt do the upgrade so I dont know.

Did you atleast collect the statistics after porting?
>> I'm a NEWBIE Sad don't understand what you mean? And how will that help me? What should I look for in the statistics?
Re: Performance Degrade when ported from 9i to 10g [message #311191 is a reply to message #311177] Thu, 03 April 2008 12:15 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
New Features Guide

Regards
Michel
Previous Topic: How to add days to a date without warnings?
Next Topic: how to get A.M./ P.M. using to_char function?
Goto Forum:
  


Current Time: Mon Dec 05 19:06:31 CST 2016

Total time taken to generate the page: 0.12927 seconds