Re: Remote or Local?

On Thu, 20 Sep 2007 22:54:46 GMT, "Dereck L. Dietz" <dietzdl_at_ameritech.net> wrote:

>Oracle 10.2.0.3.0, Windows 2003 Server
>
>Two servers: Let's call server A "Lutsen" and server B "Annapurna".
>
>Scripts are located and executed on Lutsen to read/insert/update and create
>indexes on tables (a few 30+ and 80+ million rows in size) all located on
>Annapurna.
>
>Since the tables being processed reside on Annapurna, shouldn't the code
>that gets run also be located on Annapurna so that all the network traffic
>would be eliminated?
>
>Also, wouldn't having this situation cause extensive, and unnecessary
>network traffic, which could greatly increase the time for the scripts to
>finish?
>

There is only network traffic during fetch. insert, update and creare index do not fetch anything. What is your concern exactly?
Did you check out how much network traffic you have?

-- 
Sybrand Bakker
Senior Oracle DBA