pando,

I understand what you are saying. The update statement is;
update table_name
set Meter_Charge =
(select qv.Charge_Rate
from NFTSSEE.QUOTE_LINE@LNK_NFTSSEE ql,
NFTSSEE.QUOTE_VALUE@LNK_NFTSSEE
qv, NFTSSEE.QUOTE_HDR@LNK_NFTSSEE qh
where qh.qb_ref_no =:NFTS_QUOTE_ID
and qh.qb_id = ql.qb_id
and ql.qb_id = qv.qb_id
and ql.qbl_seq = qv.qbl_seq
and ql.CHARGE_CATEGORY = 'METER'
and qv.qbv_end_date = (select max(qbv_end_date)
from NFTSSEE.QUOTE_VALUE@LNK_NFTSSEE
where qb_id = ql.qb_id
and qbl_seq = ql.qbl_seq))
where NFTS_QUOTE_ID = :NFTS_QUOTE_ID

(sorry about the formatting).

What would make this statement behave differently. In one environment, 4k is dragged across the link, in the other 56Mb is dragged across the link.