Re: Buffer Size

From: Hans Plambeck <hans_at_iris.mincom.oz.au>
Date: 24 May 93 21:21:56 GMT
Message-ID: <6463_at_iris.mincom.oz.au>

Mark Gurry (mag_at_scammell.ecos.tne.oz.au) wrote: : Beware the Incorrect Hit Ratio formula  Oracle V7
: Hit Ratio = Logical Reads / (Logical Reads + Physical Reads)

Oracle V6
: Hit Ratio = Logical Reads - Physical Reads / Logical Reads

  [logical reads = consistent gets + db block gets]   Yes, they are a bit inconsistent in their doc; if V7 %<90 increase   DB_block_buffers

  --

---

Hans-J Plambeck | hans_at_mincom.oz.au | +61 (7) 364 9999, Fax 394 2844 Mincom Pty Ltd. | Juliette St. || P.O.Box 72 | Stones Corner 4120 Qld Received on Mon May 24 1993 - 23:21:56 CEST