Re: Database link performance problem

Bernhard Acke wrote:

> 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

I think your assumptions are valid.

Daniel A. Morgan Received on Wed Jun 20 2001 - 13:26:35 CDT