Unanswered: Differerence acces path linked server Oracle 9/10
We are experiencing huge performance issues with fetching data from a linked Oracle database after upgrading the receiving database to Oracle 10g.
It looks as though all data is first fetched at the receiving end, cause temp spaces are floaded. The query ran with no problem between 2 Oracle 9i databases.
Can anyone suggest a solution for enforcing the query at the backend.
We're looking into using a specific hint to enforce this.
So far , we expect that /*+driving_site*/ could be a solution, but we are not sure about its use.
Anyone an idea?
Senior Application Developer BI
SQL, SQL server