Oracle dblink server to server transfer of data

From: <conwayjim_at_my-dejanews.com>
Date: Sun, 20 Sep 1998 03:00:32 GMT
Message-ID: <6u1r4g$vrc$1@nnrp1.dejanews.com>

Can anyone explain how oracle determines its buffering between two database servers in a distributed query? For examply...I may use sqlplus from a client with an arraysize of 50. I assume my local server will pass data to my client session in bundles of 50 rows....but the real data is on a remote server which must bundle and transfer those rows to my local server. What mechanism and parameters determine this server to server buffering?

I am also curious if oracle "snapshot" across data servers thus uses the same mechanism.

-----== 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:00:32 CDT