RE: Oracle 10g hangs intermittently waiting for I/O
- From: Fmhabash <fmhabash@xxxxxxxxx>
- To: <rprabha01@xxxxxxxxx>, Paweł Kotlarz <pkotla@xxxxxx>
- Date: Sat, 16 May 2009 18:27:33 -0400
Just to pust some numbers here...
If you produce an awr comparison report between a good and a bad period, how
are these numbers looking...
- average read ms
- physical reads / sec
Throughout my experience with IO related issues, my most effective forensic
evidence was these 2 stats on the db end. As DBA's we were asked to produce
these stats after which sys/storage admins had to explain. Im my last
engagement, we produced awr trend reports showing up 650ms read times on undo
and temp tablespaces. In this particular instance, db was migrated to a new
storage subsystem.
---------------
Thank You.
-----Original Message-----
From: Rajeev Prabhakar <rprabha01@xxxxxxxxx>
Sent: Saturday, May 16, 2009 2:50 PM
To: Paweł Kotlarz <pkotla@xxxxxx>
Cc: oracle-l@xxxxxxxxxxxxx <oracle-l@xxxxxxxxxxxxx>
Subject: Re: Oracle 10g hangs intermittently waiting for I/O
Hi Pawel,
In no particular order, please check with your sysadmins/storage admins
about the following :
a) Queue depth of the LUNs / associated optimal settings for your storage.
b) Any unsuccessful microcode/firmware upgrade on the FC fabric.
c) Double check for any combination of any FC/non-FC drives
OR any failure of drives/associated raid group rebuild errors.
d) LUN level i/o statistics and any out of ordinary observations.
-Rajeev
2009/5/16 Paweł Kotlarz <pkotla@xxxxxx>:
> Thanks, Rajeev. I appreciate your help very much!
>
> Pawel
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
