By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,119 Members | 2,086 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,119 IT Pros & Developers. It's quick & easy.

MSSQL to Oracle Migration Performance issues

P: 6
Recently we migrated our product from MS-SQL 2000 to Oracle 9i. We see lot of performance degradation due to migration. Some times complex queries are hitting 10 fold slower than SQL Server.

Reasons could be,
1.The Oracle Server with respect to configuration may have issues.
2.The SQL server optimized queries are not suitable for Oracle(The normal cases, such as datatypes, syntax etc are already taken care).

Any help on this is appreciable.. Thanks in advance.
Oct 29 '07 #1
Share this Question
Share on Google+
2 Replies


amitpatel66
Expert 100+
P: 2,367
Recently we migrated our product from MS-SQL 2000 to Oracle 9i. We see lot of performance degradation due to migration. Some times complex queries are hitting 10 fold slower than SQL Server.

Reasons could be,
1.The Oracle Server with respect to configuration may have issues.
2.The SQL server optimized queries are not suitable for Oracle(The normal cases, such as datatypes, syntax etc are already taken care).

Any help on this is appreciable.. Thanks in advance.
Hi,

We cannot help you to trace out what exactly the issue can be?
because each query will differ by its performance based on the way it is implemented. for some queries, index might not have used, some query takes time due to huge data.
could you please provide more information that could be helpful!!
Oct 29 '07 #2

P: 6
Hi,

We cannot help you to trace out what exactly the issue can be?
because each query will differ by its performance based on the way it is implemented. for some queries, index might not have used, some query takes time due to huge data.
could you please provide more information that could be helpful!!

I am talking in general , the queries were optimezed in sql server but after migration to oracle 9i they are not working fine.
I just want to know if there is some known preexisting technical reasons which is resulting in such a degradation.
Oct 29 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.