Thanx a lot Jared. With due respect to all my GURUS on this list, i start reading the docs AGAIN.
Thanx and Regards, Jp. 13-08-2003 05:46:32, [EMAIL PROTECTED] wrote: > From: [EMAIL PROTECTED] > Date: Tue, 12 Aug 2003 13:46:32 -0700 > I would say that is often the norm. > I would not say that it is however desirable. > What you need to do is ask yourself "What is the benefit > of re-reading the data in the buffer over and over?" > When a database has a high Buffer Hit Ratio it will also have a > large number of LIO's, and the reason is poorly written SQL > that reads the same data from the cache, over and over. > There papers at hotsos.com that will explain this in detail. > Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).