| Migration Oracle9 to Oracle10 [message #456975] |
Thu, 20 May 2010 09:12  |
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 #457004 is a reply to message #456975] |
Thu, 20 May 2010 12:04  |
 |
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 |
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 |
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
