Selects via DB Links - Special Tuning Considerations

We have an old 8.0.6.3 database running on HPUX 11 that currently contains our Oracle Applications 11.0.3 instance (both database and APPL_TOP) as well as a data warehouse schema. We are beginning to run out of physical room and plan on moving the data whse schema over to a Linux server running 10g (10.2.0.1) and Redhat AS 4.0. This will also free up processing resources on the old HP box.

As we cannot upgrade our 11.0.3/HP box until next year due to business reasons (read MONEY), our 8.0.6 box will still contain the jobs/reports/scripts etc. Our plan is to build a db link from the 8.0.6 box to the 10.2 box and change our code to perform our processing via this db link.

Are there any special tuning considerations relative to db links, sqlnet, etc. that I should be looking at? I've found notes on Metalink commenting on tuning sqlnet by setting the SDU and TDU sizes but I've also found notes that state this would be of limited value and the "default settings" are adequate in the vast majority of situations.

I don't have a lot of Oracle8 documentation available and am currently having trouble connecting to tahiti.oracle.com to see if there's any docs for 8 there. Thanks for any help or insights given.

Steve Received on Fri Dec 02 2005 - 13:25:37 CST