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

Microsot Linked Server & Oracle10 Performance Issues

P: 2
Hi all,

I am having major performance issues between my linked server (SQL Server) and an Oracle10 db. I have created a number of views in my SQL Server database which map to corresponding Oracle tables via a linked server.
In my Oracle environment via Sql*Plus I run a simple query (count) which does a join between a 400K table and a 2.5 mil table - this takes about 10 seconds.
In my SQL Server environment using the views created via Linked Server, the same query is still running some 15 minutes later. Task Manager indicates that the Oracle service has been constantly doing something for the last 15 minutes.

I don't know what is going - is Oracle having problems with the SQL supplied by the Linked Server? Can someone please help overcoming these problems or at least explaining what is happening.

I am on a Windows Server 2003 machine (4G RAM) running SQL Server 2005 and Oracle10 for NT. I have tried both the Microsft and the Oracle ODBC drivers and there is no difference.

Thank you.
Alex.
Feb 16 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

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