Re: clients experiencing slow connections...

Thanks for both your inputs.

the server is Windows 2000 server, ping time is reasonable, it could be possible paging on the server...
it should be the network, could be the clients, but why would the client application slow down (click on an option, and wait a long time for a response). Nothing else seems to be affected. Eventlogs don't say a thing, and nothing's changed, except new data being entered by the clients...

Oh oh, how do I specify how much phsyical memory is allotted for the database? I have 1GB of RAM, and it seems to use up a lot of it. I only want to use about 50% of it for the database, the rest should go to the OS (and other services, correct?). This could part of the problem...

"Keith Boulton" <kboulton_at_ntlworld.com> wrote in message news:ImR48.32977$ka7.5601308_at_news6-win.server.ntlworld.com...
> 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 - 21:37:51 CST