Whats the best way for 2 databases on same machine to talk

[cheguvera]

Hi,

Generally when we want 2 Oracle databases to talk, we create database link. When we access some object over a DB link, its a TNS connection. Means, even if both the databases are on the same machine (Unix), we use the listener to communicate, which is normally a TCP socket connection.

Is there any better/faster/less-resource-consumming way for 2 databases on same Unix machine to communicate ?

Thanks and Regards

 

[SantaMufasa]

Che,

I cannot think of an alternate addressability scheme (besides database links) that Oracle supports that allows you to access an different database, even if it is on the same machine.

BTW, I presume you chose your screen name after "Ché Guevara". Do you think he would (posthumously) mind that you spelled his name so differently from how he was used to spelling it?

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.