Re: clients experiencing slow connections...

This sort of problem is always tricky.

First you need to isolate the problem e.g. server, network, client.

Are the ping times to the server reasonable - if not, it could be a network problem, what is performance like to other servers? When performance problems occur, is the server heavily loaded - cpu utilisation, paging, disk i/o. In my limited experience, excessive paging tends to cause the worst performance problems. You don't say what the server is, if NT, the task manager has a performance tab showing CPU and commited bytes (memory utilisation) and available bytes. When performance is bad, can you logon to the server locally in good time? By connect, do you mean the time taken to connect to the database e.g. in sqlplus, or the time taken to load the application? Many application read a large amount of data on startup.
If you do a clean client install, how does it perform?

What has been changed: network configuration, oracle startup parameters, new applications loaded on the server, failed disk in a RAID5 array that hasn't been noticed. If NT, are there any messages in the event log?

The vendors suggestion is unlikely to help.

A Wong <ajkwong5_at_hotmail.com> wrote in message news:lUD48.7701$jb.578376_at_news2.calgary.shaw.ca...
> when I first set everything up, it ran well (setup was easy, scripts were
> provided and such). Now, 9 months later, it sucks. I wasn't a DBA, but
am
> now forced to learn because no one else knows Oracle.. trial by fire, you
> know how it is. anyways, back then, when I did a tnsping, reponse was
> 20msec. now its 200. But it should still work fine. But now, the
clients
> complain about slow connections, so slow in fact that they sometimes go to
a
> paper trail, and re-enter the data when the server is back up. I've been
> told by the vendor to export the data, then re-import it to reduce the
> number of extents, and put all data back in contiguous space, but that's
> approx. 2 hours of downtime. How can I determine why the client machines
> are slow and if it is the clients, not the server? everythng else works
> just fine on those machines...
>
>
Received on Sun Jan 27 2002 - 05:23:44 CST