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: locally managed tablespace

Re: locally managed tablespace

From: Howard J. Rogers <howardjr_at_www.com>
Date: Wed, 7 Feb 2001 19:00:36 +1100
Message-ID: <3a8100a4@news.iprimus.com.au>

Interesting -Just discovered this today. In 8.1.7 (and I believe in 8.1.6), exactly what Jonathan says should happen does.

With uniform extent size=1m, and a segment created with initial=3m next =2m, you get 3 initial extents of 1m each. Then you say "allocate extent" -and you get a single 1m extent.

What I found interesting today is that that is *not* what 8.1.5 did. In 8.1.5, you would have ended up acquiring 2 extra extents of 1 meg each, to fulfil the "2m next" requirement.

I'm slightly gobsmacked that a mere point-release should introduce such a difference in something so basic as extent allocation behaviour. Mind you, 8.1.5 is a dog of a product anyway, and 8.1.6 at least is always infinitely preferable.

Regards
HJR "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:981491865.9123.0.nnrp-08.9e984b29_at_news.demon.co.uk...
>
> No you don't.
>
> The next and pctincrease will be ignored.
> The initial will be used to determine how many
> extents of 128K will be allocated. For example
> if you set INITIAL 500K, then you would find that
> the table had been allocated 4 extents of 128K.
>
>
> --
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> Practical Oracle 8i: Building Efficient Databases
> Publishers: Addison-Wesley
>
> Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
>
>
>
> sp wrote in message ...
> >when we create a uniform extent locally managed tablespace with the
> >following command, don't we need to use storage clause
> >(initial,next,pctincrease) with the create table command?
> >CREATE TABLESPACE lmtbsb DATAFILE '/u02/oracle/data/lmtbsb01.dbf' SIZE
 50M
> > EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K;
> >thanks in advance.
> >SP
> >
> >
>
>
Received on Wed Feb 07 2001 - 02:00:36 CST

Original text of this message

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