Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Extent Allocation among Multiple Datafiles ?

Re: Extent Allocation among Multiple Datafiles ?

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Mon, 11 Sep 2000 19:45:21 GMT
Message-ID: <39bd33a8.659598442@nsw.nnrp.telstra.net>

Hi Jonathan,

I believe that round robin extent allocation was at first only used for parallel segment creation operations, but was implemented for dynamic extension in 7.3. However, from some testing I did at the time, it seemed that Oracle would reuse an extent of the correct size in any datafile rather than split an extent in the "next" datafile.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/
@   
@   Going to OpenWorld?
@   Catch the Ixora performance tuning seminar too!
@   See http://www.ixora.com.au/seminars/ for details.

-----Original Message-----
From: "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk>

I've just run a few tests of this with locally managed tablespaces, usng the 'alter table allocate extent' command, and the algorithm certainly seems to be a round-robin. I vaguely recall seeing something in the manuals to this effect too, but can't find it at present (isn't that always the way).

There is no visible clue in the recursive activity to prove that Oracle is doing a round-robin, other than the fact that Oracle loads the file$ details for all the files in the tablespace as the first step of allocating the extent. Presumably the actual decision code is hidden in dictionary cache processing of dc_used_extents.

--

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

Jonathan Lewis wrote in message
<968435216.19084.0.nnrp-12.9e984b29_at_news.demon.co.uk>...

>
>It's just occurred to me that the apparent round-robin
>may be a side-effect of the way space management
>works on dictionary managed tablespaces and not
>a planned feature. I'm going to have a proper look at
>it, and will get back to you.
>
>--
>
>Jonathan Lewis
>Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
>
>
Received on Mon Sep 11 2000 - 14:45:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US