Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> MTS vs. Dedicated connection

MTS vs. Dedicated connection

From: Charlie Mengler <charliem_at_mwh.com>
Date: Tue, 09 Jan 2001 14:08:08 -0800
Message-Id: <10736.126211@fatcity.com> 





Once again I solved a SQL*net performance problem where data was being SELECTed 
via a DB_LINK from a remote system and being INSERTed into the local instance.



The original code was going into the remote host via MTS and was taking 3+ hours
to complete. By simply changing from @PROD (via MTS) to @PROD_DED (via dedicated
listener) the run time was reduced to about 4 MINUTES! This was the ONLY change.



HTH & YMMV!

Received on Tue Jan 09 2001 - 16:08:08 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US