|| at May 20, 2011 at 11:24 am
In my opinon there is no magical number that suits any environment. It
depends on the application workload and how much IO contributes to the
workload (Contributing to top events in AWR). Higher the IO contribution,
lower would be the requirement for the response time if you intend to tune
I Do have to state that this number would be averaged over REAL physical
reads coming from the disks and logical reads coming from layers outside
oracle ( JFS cache, SAN Cache) etc
On Wed, May 18, 2011 at 3:15 AM, K R wrote:
What is the range I should be looking at for file i/o average read in
milli second in a ASM environment.
I see some of my database have average read between 3ms and 8ms .
appreciate any suggestion