Data transfer between dataservers

From: <jiconwa_at_ibm.net>
Date: Sun, 20 Sep 1998 03:11:21 GMT
Message-ID: <6u1rop$jo$1@nnrp1.dejanews.com>

Can anyone describe (or point me to something which covers) how oracle determines its buffering between dataservers involved in a dblink? For a server to sqlplus client...we know we can use "arraysize" to affect the row packaging. But what controls the movement between dataservers in a distributed query, and what parameters (static or dynamic) can be altered to affect this buffering? we are trying to understand how we can affect performance of such distributed queries.

We suspect oracle snapshot may use this mechanism.

Jim

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Sat Sep 19 1998 - 22:11:21 CDT