Re: clients experiencing slow connections...

A Wong

This sounds like a possible performance tuning job. I would start by looking at Server, network and database performance. I assume by slow connections your users are meaning that they click a button in the application and wait an age for the next screen to appear / fill etc.

I am only conversant with playing properly on Sun Solaris boxes. At a Unix level you want to check that swapping isn't occurring - On Sun top, SEtoolkit and RMCmem are good utilities to name a few, AIX nmon also seems useful - on most platforms sar is also useful. I generally tell clients that less that 25% idle CPU and > 10% WIO for extended periods shows a OS level performance issue. Swapping must be avoided at almost any cost. It is also worth looking for very hot disks - High utilisation along with low data transfer rates shows high random reads and to mountpoints with hot datafiles.

For the database pre 8i using utlbstat and utlestat from svrmgrl will give a good indication as to what the database bottlenecks are. On 8i + Perfstat will give a much better organised report and also list worst performing SQL. The key is often that incorrect or inadequate indexing has been implemented (assuming you can't re-write the application). If the cost based optimizer is being used ensure that the dbms_system.analyze_schema procedure is being run frequently as bad explain plans may be being used due to out of date statistics.

Networks are my weakest area network monitoring tools may show up hot spots in your network that are slowing down response times.

The normal quote is that 90% of performance improvement can be attained by application tuning and yet Sys admins and DBA's get asked to tune the remaining 10% far too often.

Hope this is a good started.

Nathan
"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 - 06:23:27 CST