Database link performance problem

Hi,
I am generating periodically data for a few tables on a 8.1.7 instance. These are normally 200.000 datasets using 20-something SQL-queries with a database link to a seperate 8.0.5 instance ti import data from there. The time for this job is awfull. I thought about some actions to increase data import speed:

on 8.1.5 instance:
- sql-query optimization

• alter tables to nologging
• using multiple jobs/snp processes

on net8:
- using tcp.nodelay=true

• altering packet size sdu

But my feeling is, that the main bottleneck is the database link.

What do you think about the actions above? Do you have any other hints?

Bernhard

-- 
__________________________________________________________
News suchen, lesen, schreiben mit http://newsgroups.web.de