Slow performance to Oracle linked server

• lhalbrook

  SSC Rookie

  Points: 47

  More actions

  February 10, 2009 at 9:17 am

  #200050

  Looking for advice on how to improve performance to an Oracle linked server.

  Configuration:

  Oracle 10g

  View built on Oracle (see attached Ora_CustomerAcctView.txt)

  SQL Server 2005

  Linked server to Oracle instance

  View built to Oracle data (see attached SQL_CustomerAcct.txt)

  Third party application will then use the SQL Server view to present customer information to the users. Are there some best practices or other issues we should be watching for in this configuration? Thanks.

• Vijaya Kadiyala

  SSCrazy Eights

  Points: 9119

  More actions

  February 11, 2009 at 10:02 am

  #942314

  Hi

  can you give us the volume of the data in the tables along with the Execution plan.

  How much it is taking right now? How the end users are going to query the SQL Server view??

  Thanks -- Vijaya Kadiyala

  http://dotnetvj.blogspot.com

  Thanks -- Vijaya Kadiyala
  www.dotnetvj.com
  SQL Server Articles For Beginers