Re: replication

From: bgbgbg <brian.gallagher_at_iona.com>
Date: Wed, 21 Feb 2001 13:49:36 -0000
Message-ID: <970hj7$hk0$1@bvweb.iona.com>

selects can be slow on defcall etc because the underlying tables need to read untill the
jigh watermark in other words the number of blocks in the table remain at the highest they
have ever been. i'd be very surprised if these tables were the cause of your problem.
8i is much quicker than 7 and there is a min_communication parameter which needs less
info to be compared for each update.

hth
rgds
brian

"hansley" <hansley_at_computer.org> wrote in message news:3A92B13F.60204_at_computer.org...
> hi i have a performace issue with a multimaster site replication scheme..
> looks like the view defcall and defcalldest could be the culprti as my
> select are very heasy on them..
>
> any tuning hints..
>
>
> hans
>
> openserver 5.05 and oracle 7.3.4
>
Received on Wed Feb 21 2001 - 07:49:36 CST