Re: Performance problems on OpenVMS : Was Re : Performance Tolls

In article <3qeuig$9cq_at_fnord.dfw.net>, rking_at_dfw.net says...
>
>
> This may or may not be related, but we were having very slow
 login
>times from PC's to VMS servers, but fast on VMS. Even when SQL*NET 2.1
>was used in both enviroments, logins on VMS using SQL*NET were in the
 2-10
>second range, and in the 40-60 second range on the PC. We are using
>WFW/TCP winsockets (vxd) tcpip and sqlnet 2.1 (including nameserver).
>By hard coding in the tcpip addresses, we cut down the login time from
 45
>to 15 seconds. By using tnsnames.ora and not nameserver, it went down to
>2-4 seconds. On VMS directly, with sqlnet, it's fast no matter which
>configuration.
>--
>Bob King - rking_at_dfw.net
>business ph. - (817) 551-8223
>

As far as I know we are using tnsnames.ora. I have gotten several messages stating that the server specified was not in the tnsnames.ora file.

As to being fast on VMS. No it's not. Not here any way. I have a simple metadata request (Column names, indexes, etc. no data) for 3 tables. We have seen it take 60 seconds to return the information and up to 25 minutes for the same request. At both times all systems were being monitored and the systems seemed to be running about the same. Whenever we go at Oracle the Oracle Server always goes nuts and gets 95% of the CPU. Is that normal ? It seems if that is the case you'd need a very large vax just for your Oracle Server and I know our company doesn't have that kind of money let alone smaller companies out there.

Re: PC access, I am going to pass this message on to my PC people and see what they are doing because they are also having performance problems accessing Oracle on OpenVMS machines.

Thanks, for your message and I'll let you know what happens.

Peter Farrell
peterf_at_cognos.com Received on Thu Jun 01 1995 - 00:00:00 CEST