Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Tuning data transfer between Oracle databases.

Tuning data transfer between Oracle databases.

From: RastM <tkupp_at_pacifier.com>
Date: 1997/10/05
Message-ID: <34371046.0@news.pacifier.com>#1/1

I've got three Oracle databases. On one machine I've got a V6.0.37 and a V7.0.16 database. On another machine I've got a V7.3.2 database. I'm passing data from the V6.0.37 database to the V7.3.2 database via a SQL script executed by the V7.0.16 database:

	INSERT INTO table_at_link_to_V73_database
		SELECT * from table_at_link_to_V6_database

.
.
.

The link to the V6.0.37 database is SQL*Net Pipes and the link to the V7.3.2 database is SQL*Net TCP/IP.

What kinds of tuning can I do to make sure this is working as fast as possible (rollback segment sizes, SQL*Net parameters, init.ora parameters, etc.)? How much do I need to worry about the V7.0.16 database? All I'm using it for is to execute the SQL script.

Any advice is appreciated.

-- 
tkupp at pacifier dot com
Received on Sun Oct 05 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US