SQL Server Linked Oracle Server

ALSO_DB
ALSO_DB used Ask the Experts™
on
I have in my SQL environment a  linked Oracle Server.

If I run a query against my linked Oracle Server the query doesn't use the Oracle Indexes. So the duration of the query tooks very long. On the Oracle server direct the Query took only seconds.

How could I made the right setup?

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
no matter you are executing query from linked server or directly from oracle server, Index is going to be used I guess. Network may be culprit in your case.

Author

Commented:
the network isnt the culpirt!!!!!

Author

Commented:
I looked with the oracle analyser and saw that sql made a full table scan!
Acronis in Gartner 2019 MQ for datacenter backup

It is an honor to be featured in Gartner 2019 Magic Quadrant for Datacenter Backup and Recovery Solutions. Gartner’s MQ sets a high standard and earning a place on their grid is a great affirmation that Acronis is delivering on our mission to protect all data, apps, and systems.

Commented:
See if the attached webpage helps. Seems like there is a bug.
Please change the extension to .htm after you have downloaded the file.
P.

How-Improve-Linked-Server-Perfro.txt
Mohed SharfiVice CEO

Commented:
Hi ALSO_DB,
how are you doing
try check the following in the Linked server setup for Oracle Provider for OLE DB
"Dynamic Parameters"
"Allow InProcess"
thanks

Author

Commented:
Dear mSharfi

"Dynamic Parameters" and "Allow InProcess" activated, but still slow like a snake...
Vice CEO
Commented:
ok,
please try to install Cumulative update package 3 for SQL Server 2005 Service Pack 2
http://support.microsoft.com/kb/939537
thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial