Re: dblink question....

What versions are your two databases? We've had similar problems with two databases that were on two different versions (Oracle 7 & 8). The frequency of this problem has been reduced once we put both databases on the same version (Oracle 8.0.5).

Before we made both databases the same version, we found that the connections to the Oracle 7 database were just sitting there idle. So we implemented a profile for the connected users and limited their idle time. This disconnected the session if it sat there idle for a number of minutes.

HTH,
Brian

gdas wrote:
>
> Sorry for all the questions...
> I have 2 db instances, connected via dblinks. I've got some
> shared tables which I have synonyms created for. I'm noticing
> that connections are persisting across the links even after
> transactions are completed.
>
> For example, 10 connections into instance #1 that update a
> synonym for a table on instance #2, open 10 sessions on instance
> #2. (verified from v$session)...However, once the inserts are
> finished, the connections are still held on instance #2.
>
> Is there anyway to free up these connections over the dblink
> after the transactions are finished. I'm concerned about
> resource consumption of instance #2.
>
> As an alternative, I've thought about using replication. Or
> possibly creating my own replication procedure (combined with
> the built in oracle scheduler).
>
> Thanks for any advice.
>
> -----------------------------------------------------------
>
> Got questions? Get answers over the phone at Keen.com.
> Up to 100 minutes free!
> http://www.keen.com
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================