For my edification, can you please provide these metrics ... - LIO/sec - PIO/sec- if you look at your sql ordered by PIO, what do you see there. Can you tell from the code what tables are being read from disk and why?
Also, on a finely tuned DB and in the absence of any other significant wait events (e.g. log sync, scattered ...., etc), why wouldn't you expect to see DBFSR as the top one. After all ,that's what the DB should be doing serving user requests. The question, then, becomes how costly it is. If you are doing less than 20ms, then you have no reason to loose sleep over it (not that you are).
Thank you Fred Habash, Lead Oracle DBA (OCP 8i,9i) Oracle Team Portal http://spc-00sv0d03e3.spc.supc.com/ddcports/oracle/ _______________________________________________________________________________________ACS HealthCare Solutions Dearborn, MI | Off.: 248-226-8778 | fhabash@xxxxxxxxxxx | http://www.acs-hcs.com
-- //www.freelists.org/webpage/oracle-l