Re: Databse File layout on only 4 drives Ideas?

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Sat, 1 Feb 2003 12:30:55 +1100
Message-ID: <LiF_9.37810$jM5.96195@newsfeeds.bigpond.com>

"Joel Garry" <joel-garry_at_home.com> wrote in message
> > > I've always had a problem with this statement. Wouldn't a db buffer
> > > cache hot-spot like this be a "dirty write" attractor, often flushing
> > > and making a hot-spot on the disk?
> >
> > No, because there's no relationship between the adjacent-ness of blocks
on
> > disk and what DBWR decides to flush.
>
> Even in the case of, say, doing an update on everything in a partition
> that takes an hour during an otherwise low-usage time?

Probably even in such a case, no. The fact that you're doing a big update means a lot of stuff will be flushed, fine. Will that be to adjacent blocks on disk? Not necessarily. The blocks within an extent are not physically adjacent to each other, raw partitions aside.

HJR Received on Fri Jan 31 2003 - 19:30:55 CST