Re: How does oracle write to datafiles?

From: Ronald <devnull_at_ronr.nl>
Date: Mon, 28 Jan 2002 08:56:38 +0100
Message-ID: <280120020856382253%devnull@ronr.nl>

In article <6P458.60048$bL5.2814127130_at_newssvr15.news.prodigy.com>, Angry Garden Salad <angry_garden_salad_at_sbcglobal.net> wrote:

> Hi,
> I have a performance question about how oracle writes to datafiles. If I
> have a Tablespace (A) and I have 2 datafiles in it, each being on the same
> disk, does oracle attempt to write to both datafiles at the same time like a
> striped disk when inserts are being done? Or does it write to each datafile
> randomly filling each evenly as time goes on. Would there be a benefit to
> put each datafile on totally separate disks? Would there be a performance
> increase? Why, why not? If someone has a white paper on how oracle does
> this, that would be great. Thanks in advance...

in 7.3 it fills the first file and continues in the next. In 8i it stripes.

Ronald.
http://ronr.nl/unix-dba Received on Mon Jan 28 2002 - 01:56:38 CST