Re: Drastic performance drop in DB links

From: Steve Adams <steveadams_at_acslink.net.au>
Date: 1998/01/28
Message-ID: <34ce874c.78852608@newsserver.trl.oz.au>#1/1

Hi Rich,

Look for HIGH version counts in v$sqlarea. If so, you have probably hit bug #315199. I don't believe that there is a backport to your version, but there is an effective workaround.

Regards,
Steve Adams
steveadams_at_acslink.net.au

---

On Fri, 23 Jan 1998 20:11:16 -0600, rich_tefft_at_esd.tracor.com wrote:

>I have (2) v7.2.3 instances on a Sun UltraEnterprise II server. In each
>instance, I have a private DB link to the corresponding account on the
>other. Passwords are hard-coded into the links. Performance has been
>great, almost no difference when selecting data across the link.
>(Distributed option only installed). Over the last 2 days or so,
>performance across the link has dropped tenfold. The links work, but
>performance is nearly useless. This occurs even when the machine has
>near zero load and I am the only one on it. No changes to the O/S,
>Oracle, or databases have been made.
Received on Wed Jan 28 1998 - 00:00:00 CST