Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How does oracle write to datafiles?
It is going to allocate space in the first file and use the space there. If
it cannot create an extent in the first file then it will go onto the next
extent.
Jim
"Angry Garden Salad" <angry_garden_salad_at_sbcglobal.net> wrote in message
news:6P458.60048$bL5.2814127130_at_newssvr15.news.prodigy.com...
> 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...
>
>
>
>
>
Received on Sun Jan 27 2002 - 23:48:28 CST