Home » Other » General » Migration Oracle9 to Oracle10 (Oracle 9.2, Windows Server 2003)
Migration Oracle9 to Oracle10 [message #456975] Thu, 20 May 2010 09:12 Go to next message
baumrat
Messages: 2
Registered: May 2010
Junior Member
Our Warehouse Management System is running on a Windows 2003 Server. We use a separate Windows 2003 Server
as database server running Oracle 9.2.
For increasing the performance we discuss several possibilities.
One of these possibilities is the migration of the database from Oracle9 to Oracle10.
Is there any information available concerning the performance behavior of the planned migration?

Thanks in advance.
Re: Migration Oracle9 to Oracle10 [message #456978 is a reply to message #456975] Thu, 20 May 2010 09:26 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Define performance behavior of the planned migration?

However I suspect the only real answer is you are going to have to test it yourself.
Re: Migration Oracle9 to Oracle10 [message #456979 is a reply to message #456975] Thu, 20 May 2010 09:26 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Is there any information available concerning the performance behavior of the planned migration?
It depends
Performance will stay the same, get better or get worse depending upon your specifics.
Re: Migration Oracle9 to Oracle10 [message #457004 is a reply to message #456975] Thu, 20 May 2010 12:04 Go to previous messageGo to next message
Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA
Senior Member
BlackSwan and CookieMonster are correct. There are improvements with each release that have the potential to improve overall performance. Your milage will vary.

However if you are having performance problems that are bad enough that you want to talk about them then placing your hopes on an upgrade to solve them is a mistake. You should instead do a typical tuning effort. An upgrade can be part of this tuning effort but not its foundation.

1) Check V$SQL for the 1% of expensive SQL that is consuming 90% of your resources and tune it.
2) Check for the typical mistakes that most databases and applications make
   a) look for missing PK/UK/FK constraints
   b) look for FK constraints not supported by an index
   c) look for lack of bind variable use
   d) look for use of dynamic sql
   e) look for use of permanent LOBS/CLOBS to get around the old temporary lob issue
   f) make sure stats are collected correctly for your version of Oracle
3) Check your SLAs to see that you are making them.  This will give you insight into opportunities.
4) Consider warehouse orientied Oracle technologies
   a) change physical storage to match your most demanding accesses
   b) use Oracle Analytics where possible
   c) revalute the value of bitmap indexes and how your are or are not using them
5) Evaluate a newer Oracle release for its potential benefits.


Kevin

[Updated on: Thu, 20 May 2010 12:06]

Report message to a moderator

Re: Migration Oracle9 to Oracle10 [message #457011 is a reply to message #457004] Thu, 20 May 2010 13:45 Go to previous messageGo to next message
baumrat
Messages: 2
Registered: May 2010
Junior Member
I want to state the situation more precisely:
In the moment we have no performance problems.
But we expect a larger load on the database in the near future (e.g. increasing data volume of about 20 - 30 %, further activities and so on).
We try to find possibilities to handle this larger load, because we expect performance problems thereby. And we hope that the migration can contribute to increasing the throughput and to solving the expected problems.
Re: Migration Oracle9 to Oracle10 [message #457012 is a reply to message #457011] Thu, 20 May 2010 13:48 Go to previous message
Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA
Senior Member
Well all I can really say is you should not expect a migration to result in an across the board 30% improvement in performance. If that were so, everybody would migrate the day it came out and Oracle would be hocking such a benefit in no uncertain terms. You would not have to ask if it was true, it would be obvious. So, the short answer then is NO.

Good luck, Kevin
Previous Topic: Seeking recommendations on server/Oracle setup
Next Topic: Location of Programs
Goto Forum:
  


Current Time: Thu Mar 28 21:00:55 CDT 2024