Re: Cursor Over a DBLink

Marco, run an explain plan on the SQL. Take the SQL in the other column, which contains a copy of the SQL statement sent to the remote system, and explain it on the remote system. This will let you see how the query is being processed and perhaps let you determine if you can do anything that will aid the optimizer such as add an index.

You might want to look at the bulk load options of Oracle. Version 9.2+ allows you to identifty individual row errors while allowing the bulk operation to succeed.

If the total quantity of data being selected is actually fairly small you might be able to select it into a pl/sql table (array) and process the data in memory.

Different queries may require different techniques to be used to solve the problem in an efficient manner. Sometime one size does not fit all.

HTH -- Mark D Powell -- Received on Mon Sep 12 2005 - 20:12:31 CDT