Re: Poor mans RAID10...

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Thu, 18 Mar 2004 16:49:04 +1100
Message-ID: <40593860$0$16496$afc38c87@news.optusnet.com.au>

"DD" <denisdo_at_yahoo.com> wrote in message news:3abbfcd5.0403172112.7b11103e_at_posting.google.com...
> > Does anybody know about how oracle (9i, Linux) actually allocates space
> > across the different datafiles?
> > Is one table always in one file or is the granularity the extent?
>
> Hi Guys!
> Correct me if I am wrong - but it looks for me that Oracle allocates
> SEGMENTS to datafiles and all extents allocated via robin-bobin INSIDE
> of Segment.
> That means, you will never have extents from single segment on
> different datafiles. However, extents from different segments can be
> located on different drives (if segments are)
>
> Am I right or not?:-)

You might just care to peruse the rest of the thread, where you will discover that you are completely wrong.

Sorry
HJR Received on Wed Mar 17 2004 - 23:49:04 CST