| Net8 connection has slowed since last week [message #367589] |
Wed, 13 January 1999 00:17  |
Don Cavin
Messages: 2
Registered: January 1999
|
Junior Member |
|
|
|
Running 8.0.5 on Windows NT SERVER configured as a primary domain controller and print server with 160 MEG memory and plenty of disk. Last week installed several clients and changed their TNSNAMES.ORA to reflect our server and port 1526 on TCP/IP. Linking to Oracle tables from MS ACCESS 97 front-end so set up system DSN that is configured on each machine. Had 3 clients last week that connected fast from SQL PLUS 8.0 or ODBC through Access. Now, whether Windows 95 Client or 4.0 Workstation, takes three or four minutes to connect, even directly into SQL*PLUS. Do I need to set up a different file DSN? We are using Oracle 8.0.5 driver and all Microsoft drivers, no INTERSOLV. Any suggestions of how to troubleshoot this would be greatly appreciated. I know how to trace but don't know what to look for. Thanks, Don
|
|
|
|
| Sorry! SQL*Plus perf. would make DSN irrelevant [message #367590 is a reply to message #367589] |
Wed, 13 January 1999 00:21  |
Don Cavin
Messages: 2
Registered: January 1999
|
Junior Member |
|
|
|
The problem has to be NET8 and something with the TNSListener. I read something on ORAFAQ about dead database connections. IF these are like rogue UNIX processes that stay open in the background, this would sure explain the worsening performance. Once again, any ideas would be helpful. Don
|
|
|
|
| Re: Net8 connection has slowed since last week [message #367604 is a reply to message #367589] |
Sat, 13 February 1999 08:47 |
Ales
Messages: 11
Registered: February 1999
|
Junior Member |
|
|
I think you should first look at your server real memory (maybe paging is slowing down connect time!?), then with performane monitor try to determine bottleneck on your PDC (also check Control Panel--> Network --> Services --> Server --> Properties --> Maximize trhroughput for network applications must be selected).
bye,
Ales
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
