Physical Read Waits less than Physical Reads

Hi All,


For some of my sessions I see, for example:


V$SESS_IO shows 200,000 physical  reads
 
V$SESSION_EVENT shows < 100,000  total waits for “db file * read”  (and “read 
by 
other session”)  etc.
 
Does that mean half my physical  reads didn’t wait at all?  How is that 
possible?  (I see this under high load - under low load number of reads is 
approximately the same as the number of waits for the same SQL)


I'd be very grateful if you could explain this observation to me! (Platform is 
10g on AIX)

Thank you!

Charlotte



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

Other related posts: