sqlplus too slow in Windows 2000

[sudheer_nm]

Hi Guys,

Connecting to database thru sqlplus takes long time on W2k, Oracle 9i when compared with NT,Oracle 7.x.
What could be the reason? a know problem??
Because of this my ported odbc application from NT to 2k facing some major performance problem.

[patel_dil]

What is the value of NAMES.DIRECTORY_PATH in SQLNET.ORA? If you are using TNSNAMES, set it to just NAMES.DIRECTORY_PATH = (TNSNAMES), commenting/removing out all others.

This may not be your problem, but one of the possibilities your connection is taking long.

[sudheer_nm]

Ya i am using a tnsnames.ora file which contains 3 db instances

should i add NAMES.DIRECTORY_PATH = TNSNAMES.ORA in SQLNET.ORA
if not let me know the correct syntax.

[shashikumar]

1. Remove the files d:\oracle\ora81\otrace\admin\process.dat and d:\oracle\ora81\otrace\admin\regid.dat. Oracle suggests running the "otrccref" executable after removing the files. I never have and haven't had any problems.

2. Check out any parameter set in listener.ora file. Like connect_timeout

3. Checkout with server resources.

[patel_dil]

Originally posted by sudheer_nm

should i add NAMES.DIRECTORY_PATH = TNSNAMES.ORA in SQLNET.ORA

Yes, try it.

Syntax :
Add the following line as it is in sqlnet.ora.

NAMES.DIRECTORY_PATH = (TNSNAMES)