Whenever we telnet and execute a job without connect string, the job runs within 15 minutes. However if the same job is executed with connect string (@dbname), then the same job takes 2 hours. I am enclosing a zip file which contains listener.ora and tnsnames.ora. How to solve this problem ?
Thanks in advance.
The following are entries of listener.ora and tnsnames.ora
# LISTENER.ORA Configuration File:/oracle/app/oracle/product/8.1.6/network/admin/listener.ora
# Generated by Oracle configuration tools.
Your problem may not have anything to do with the network configuration. For example, if you're doing lots of row by row fetches across a slow network, you will get quite poor response time. Possible solutions would be to do more array fetches or to move most of the work into a stored procedure on the target machine. What type of job are you running exactly ?