Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Tuning data transfer between Oracle databases.
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 comReceived on Sun Oct 05 1997 - 00:00:00 CDT