This content has been marked as final. Show 4 replies
Do you know how could be set the isolation level to try other ways ?
READ UNCOMMITTED ??
Oracle doesn't support READ UNCOMMITTED. Even if it did why would you want to pull data that might get rolled back after you pull it?
You can't fix a problem until you know what is causing the problem. Guessing doesn't work.
Mark this question ANSWERED and repost it in the SQL and PL/SQL forum
PL/SQL and SQL
Before you post read FAQ #3 in the *** SQL and PL/SQL Frequenty Asked Questions (FAQ) *** at the top of the forum thread list
3. How can improve the performance of my query? / My query is running slow.
Also be sure and post your version/patch level.
Search MOS bug database for ansi join dblink. Try rewriting your ansi join in the old oracle syntax, and look up the driving site hint in the docs to see if you can push some of the work there, rather than sucking all the data over then joining.
Also see http://jonathanlewis.wordpress.com/2008/12/05/distributed-dml/