Re: Average physical read times
Date: Wed, 24 Sep 2008 19:49:16 +0200
Message-ID: <486b2b610809241049y467c2756g40a3846b9950700a@mail.gmail.com>
Hi Daniel
I was experiencing the exact same situation at a client (probably even worse, with sql trace reporting single block io times of up to 4 seconds for 1 block).
The root cause was determined to be a problem with the microcode on the SAN, where each LUN created would not get striped accross more than 1 rank, and would therefore consist of very few spindles. The resulting contention on the individual disks was causing those enormous latency problems.
Verify with the storage people if they're running the latest microcode on the IBM storage array.
Cheers
Stefan
On Wed, Sep 24, 2008 at 6:17 PM, Daniel Fink <daniel.fink_at_optimaldba.com> wrote:
> In a recent optimization effort, I found what I think are high physical read
> times. For example, a single block read was averaging 11 milliseconds with a
> max of over 1 second (tkprof output). For this session, single block reads
> consumed over 80% of the response time, so this is of concern.
>
> We are running Oracle 10gr1 on AIX with an IBM storage array (shared amongst
> many servers). I suspect there is some optimization that can be done at the
> storage array level. If 11 milliseconds is well above average, this will
> help in engaging that team in the process.
>
> For those of you running statspack. AWR or other monitoring tools, what are
> the average single block read times you are encountering on a good system?
> If you are running on an IBM storage array, have you found any specific
> issues/fixes?
>
> Regards,
> Daniel Fink
>
> --
> Daniel Fink
>
> OptimalDBA.com - Oracle Performance, Diagnosis, Data Recovery and Training
>
> OptimalDBA http://www.optimaldba.com
> Oracle Blog http://optimaldba.blogspot.com
>
> Lost Data? http://www.ora600.be/
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- ========================= Stefan P Knecht Senior Consultant Infrastructure Managed Services Trivadis AG Europa-Strasse 5 CH-8152 Glattbrugg Phone +41-44-808 70 20 Fax +41-808 70 12 Mobile +41-79-571 36 27 stefan.knecht_at_trivadis.com http://www.trivadis.com OCP 9i/10g SCSA SCNA ========================= -- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 24 2008 - 12:49:16 CDT