Re: DBLINKS Vs ... (3rd time lucky)
Date: 22 Sep 1994 04:53:00 GMT
Message-ID: <35r2jc$be4_at_dcsun4.us.oracle.com>
tulcoc_at_ccnet.com (Ajoy Cherian) writes:
|> 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.
Unfortunately, the best method sort of depends on the application and
resources.
MTS does not directly result in less network overhead. The biggest
impact might be in reducing the number of processes just sitting
idle on the server.
|> What about the SQL statements issued after a connect.
After a connection to Oracle is established (MTS or not) the
listener is no longer involved in the loop.
Roderick Manalac
Oracle Corporation
Received on Thu Sep 22 1994 - 06:53:00 CEST