Average physical read times
- From: Daniel Fink <daniel.fink@xxxxxxxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 24 Sep 2008 10:17:42 -0600
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