Re: How does oracle write to datafiles?

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: 28 Jan 2002 02:49:08 -0800
Message-ID: <a8aed4.0201280249.43d557d0@posting.google.com>

Like Ronald as told 8i stripes...

And if u have given minextents greater than 1 then the extents are allocated equally from both the files.

HTH Regards,
Ganesh r

Ronald <devnull_at_ronr.nl> wrote in message news:<280120020856382253%devnull_at_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 - 04:49:08 CST