DBLINKS Vs ... (3rd time lucky)

From: Ajoy Cherian <tulcoc_at_ccnet.com>
Date: 15 Sep 1994 13:54:11 -0700
Message-ID: <35ac9j$rce_at_ccnet.ccnet.com>

Hi,

Inorder to access data from another database while connected to a database (in PRO* appilcation) we are considering the following two options.

Set up dblinks
or use AT<dbname> in the sql statement and with the MTS option. or use AT<dbname> in the sql statement and no MTS.

Does one of the above method has any perfomance advantage over the other one. Will SQL*Net reduce any overheads with the MTS.

With the MTS option and SQL*Net V2 ,a the connect to the database is slow since V2 requires a reconnect to the despatcher process. What about the SQL statements issued after a connect. Do they have to go thru SQL*Net(listener) again or is it a direct communication with the despatcher process with no additional overhead as when u have dedicated servers instead of MTS.

Would like to have ur valuable opinion

Platform : Sparc 20 , solaris 2.3
Oracle : V 7.0.16.6 , Sql*Net V2

Thanks in advance for any inputs
Regards
Ajoy Received on Thu Sep 15 1994 - 22:54:11 CEST

This message: [ Message body ]
Next message: Deniz Akkus: "trying to purchase a highly reliable ORACLE server configuration..."
Previous message: Virinchipuram J. A.: "Oracel-SQL Question"
Next in thread: Roderick Manalac: "Re: DBLINKS Vs ... (3rd time lucky)"
Reply: Roderick Manalac: "Re: DBLINKS Vs ... (3rd time lucky)"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message