dblink question....

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 Received on Thu Aug 10 2000 - 00:00:00 CDT