From dharan71@yahoo.com Thu, 20 Sep 2001 05:18:44 -0700 From: Dharani Ravi Date: Thu, 20 Sep 2001 05:18:44 -0700 Subject: TNS Names connection takes lot of time - HELP Message-ID: MIME-Version: 1.0 Content-Type: text/plain Dear friends, Oracle Version 8.1.6 OS Sun Ver 8 >From one of the client machines if I telnet and execute sqlloader for loading data without connection string the process takes 5 minutes to complete (25 lac rows). However if I use connection string (connect scott/tiger@test), then the process takes 1 hour to complete. In listener.ora file the protocol is defined as TCP. The client is in the same network. Why it takes one hour if I use connection string ? Could anyone pl help ? Thanks in advance. Dharan __________________________________________________ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dharani Ravi INET: dharan71@yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).