Re: Slow intermittent application response time

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

--
http://www.freelists.org/webpage/oracle-l