Re: Slow intermittent application response time
- From: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
- To: rachidtamba@xxxxxxxxxxx
- Date: Wed, 1 Mar 2006 14:11:07 -0600
Rachid
> What is the best strategy to resolve the issue of slow intermittent
> applicartion response time ?
Facts. Read Optimizing Oracle Performance by Cary Millsap. Try to measure
response time as close as possible to the user. Often users will pick out a
single incident and exaggerate it. Once you are able to measure performance,
try to narrow down where the problem occurs. Is it slow for all users or
just a few? All applications or just one? When users are experiencing a
slowdown, log in with SQL*Plus and try a few queries. This will help
exonerate or implicate the database. If it is a database slowdown, I
personally like STATSPACK because it can gather a wealth of information in
just a couple of snapshots. Often GUI tools slow down with the database and
you can't drill down to the problem.
Dennis Williams
Other related posts:
