I am facing a typical problem with sqlldr. We are able to load huge volumes of data into tables with out any problem. In the WIN-NT 2000 server, when we invoke the sqlldr from command line, it is taking 5 seconds to complete althoguh no data is available in the input text file. If i try the same thing on some other machine it is only taking .5 secs. Can any body let me know what can be the reason.
Your answer helped me. Thanks. I tried to validate whether it is connection problem or not. Now i tried sqlplus instead of sqlldr , it is also taking 5 secs. What i am supposed to do now. Any suggestions.
I'd be 99% certain it's an IP config issue - not an Oracle issue. Maybe someone here is aware of an Oracle problem though - but I've never seen/heard of any in this area.
If it is IP related, you are probably best talking to one of the Network guys or there may be someone on here with the relevant knowledge.
It's a huge area with many possible causes, do you run a local DNS at your site? If so - does your Win2K box know about it or is it just having to shout at the entire network waiting for any DNS to answer?
I'd also look into whether Win2K supports a 'hosts' file where you can specify names and IP's without them having to be resolved. This will only work for static IP's of course.
I'm no expert on IP I'm afraid, hopefully someone here can be of more use.