Alternatives for Dblink in oracle? we have an SSIS job that inserts data into a table in server A from data in table which is located in some other server B.

For this,we are making use of dblinks to connect to other database . But, this is causing lot of performance issues and job is failing because it is taking lot of time to execute the query.

So, i would like to know , what are the alternatives for Dblinks. The one thing i got is , using Materialistic views .

BUt i am not sure , how that works ?  Please suggest..
A materialized views is not a replacement for a database link. It would likely create a local materialized view using data pulled accross a database link. What you need to do is tune the query that you are using for your materialized view.

Run the query in sqlplus with timing and autotrace turned on. Look for cartesean joins, full table scans and sorts. There are probably some additional indexes or changes to indexes that you can make that will make the query cheaper to run. You want all of the filtering and sorting to happen on the source side of the link so that you are bringing accross as little data as possible.