Re: Selects via DB Links - Special Tuning Considerations

On Fri, 02 Dec 2005 21:09:38 GMT, "Bob Jones" <email_at_me.not> wrote:

>
>"Steven Kondolf" <skondolf_at_nospam.rochester.rr.com> wrote in message
>news:ek61p11tplu1ghrt7srtmum7hodrp1pf55_at_4ax.com...
>> 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
>
>You might run into problems since version 8 is no longer supported.
>Depending on your applications, this change could generate a lot of network
>traffic, and make your queries run slower.

Agreed, which is why I'm trying to find out what I can do (if anything) to minimize or at least optimize this traffic while still using db links.
>
>Oracle docs are all over the internet, not just on tahiti.

I'll have to do more searching.

Thanks.
>
Received on Sat Dec 03 2005 - 10:31:16 CST