Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: unable to produce sequential writes to redo log

Re: unable to produce sequential writes to redo log

From: Paul M. Aoki <aoki_at_faerie.CS.Berkeley.EDU>
Date: 6 Oct 1999 20:23:04 GMT
Message-ID: <7tgb38$og$1@agate-ether.berkeley.edu>


"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> writes:
| Redo writes in in a multiple of what it
| considers to be the device driver block
| size (which is often 1K, sometimes 512
| bytes).
|
| Consequently you can do a 1K redo write
| which requires the file system to do a 4K
| or 8k read into which the 1K change is
| written.

that makes a LOT of sense given that i'm seeing a 1:6 or 1:7 ratio between reads and writes.

i'm surprised this isn't (more of) a FAQ item given how badly it kills you...

thanks!
--

  Paul M. Aoki         | Computer Science Division, EECS #1776
  aoki_at_CS.Berkeley.EDU | University of California
                       | Berkeley, CA 94720-1776 USA
Received on Wed Oct 06 1999 - 15:23:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US