Re: DB File Sequential Read Waits

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: 5 Jan 2004 13:33:30 -0800
Message-ID: <73e20c6c.0401051333.705e3aaf@posting.google.com>

pharfromhome_at_hotmail.com (Geomancer) wrote in message news:<cf90fb89.0401040937.52d574e9_at_posting.google.com>...

> You mention checking disk reads.
>
> Do you subscribe to the notion that one should only tune to reduce logical I/O?

Dunno about JL but here is something for you to think about, instead of spending your time trying to post "examples" to support old notions:

In Oracle and abstracting abnormal cases, you CANNOT cause a physical I/O that does not ALSO cause a logical I/O.

Tune ONLY for logical I/O and I can GUARANTEE you the physical I/O will take care of itself.

Capice?

Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam Received on Mon Jan 05 2004 - 15:33:30 CST