Re: Extent Allocation among Multiple Datafiles ?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 7 Sep 2000 08:53:20 +0100
Message-ID: <968314038.14856.0.nnrp-03.9e984b29@news.demon.co.uk>

I can't remember which version of Oracle (possibly very late 7) it appeared in, but with multiple files in a tablespace Oracle uses a round-robin method for allocating extents on a per-segment.

i.e. if you create two tables, their first extents will both be in 'file 1', their second in 'file 2' and so on.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

EnderW wrote in message <8p7207$9rf$1_at_nnrp1.deja.com>...


> Hi,

>  I was reading a book on DB2 ( no flames :) . Anyhow while reading a

>book, I wondered if I have a tablespace that has 3 data files on 3

>diff. filesystems. Does Oracle have a switching mechanism among those

>datafiles ? Suppose I grab one extent and use it and the next extent I

>grab it from the second datafile and the third extent from the third

>datafile ? Or grab until we exhaust all the space on the datafile then

>move on to the second one ? Thanks.

>

>PS. If I am missing something, please excuse me since I am close to

>12AM..

>

>--

>Ender Wiggin

>

>

>Sent via Deja.com http://www.deja.com/

>Before you buy.

Received on Thu Sep 07 2000 - 02:53:20 CDT