Re: clients experiencing slow connections...

Have you tried running a SQL trace on a session with poor performance?  Set timed_statistics=true to get timings. Once you have a trace file, then you may use tkprof to format the trace file. Ex. of tkprof

tkprof ora_somedb_11111.trc output.text explain=username/password sys=no sort='(exeela,fchela,prsela)'

This will sort the output by execution elapsed, fetch elapsed, parsed elapsed. It should show whether the application that is running, may not need to be tuned, however, in my experiences, that is never usually the case.

In regards to the amount of memory you have allocated for Oracle and Paging. I would check the following parameters and add up the memory used: DB_BLOCK_BUFFERS(note that this is the number of blocks for the buffer cache, take this times your block size), SHARED_POOL, SHARED_POOL_RESERVED_SIZE, JAVA_POOL_SIZE. These should give you a good idea as to how much memory is allocated to Oracle. It is also important to note how many users are logging onto the instance since each user is assigned some memory outside of the Oracle Instance. So, if you're paging quite, you could be paging out the SGA which is really bad. If this is the case, consider adding more memory or reducing the size of the SGA.

Another performance tuning item, if this an 8i db, install and run STATS Pack. This will give you hit ratios of the buffer and library cache and a ton of other information.

HTH
Pete's

"A Wong" <ajkwong5_at_hotmail.com> wrote in message news:<hgK58.26949$jb.1361680_at_news2.calgary.shaw.ca>...
> I've rebuilt several workstations, client worklstation performance is a
> little better, but connection is still slow. My user account connects
> quickly, but others is slow. But, my user account is not as heavily used.
> It seems people with heavily used accounts tend to be slower. How can I
> figure out why?
> "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 Wed Jan 30 2002 - 08:10:42 CST