Re: Why is NEXT_EXTENT changing all the time?

You are right!

How come I didn;'t think of it!? I took for a certitude that I changed them all to PCTINCREASE=0 a while ago...

Good lesson. We should never assume.

So Oracle actually changes the value for NEXT_EXTENT according to PCTINCREASE for every new extent created? And it reverts that value when the table shrinks. Interesting, indeed!

Thanks!

--
Syltrem
http://pages.infinit.net/syltrem (OpenVMS Web Site)




"David Fitzjarrell" <oratune_at_aol.com> wrote in message
news:94nb4j$m5j$1_at_nnrp1.deja.com...


> In our last gripping episode "Syltrem" <syltrem_at_videotron.ca> wrote:

> > I am trying (hard!) to get same size extents throughout my

 tablespace, but


> > Oracle *8.0.5.1) won't let me do it.

> >

> > NEXT_EXTENT keeps changing for about 20 tables (out of 1500). Please

 someone


> > have a look at the following sequence and tell me what I do wrong or

 do not


> > understand!

> > Note: I picked a bad example maybe (numbers are look alike)

> > I want extent size = 160 (one-sixty) and Oracle changes for 168

> > (one-sixty-eight)

> > a) table created with extent=160k

> > b) import data

> > c) extent now 168

> > d) truncate table

> > e) extent back to 160

> >

> > Thanks!

> >

> > SQL> select owner,next_extent/1024 from dba_tables where

> > table_name='GEM_RELATIO

> > NS';

> >

> > OWNER                          NEXT_EXTENT/1024

> > ------------------------------ ----------------

> > FINANCE                                     160

> >

> > $ imp finance/pwd ignore=y file=$1$DGA56:[SYLVAIN]MITFINSMALL.DMP

> > tables=GEM_RELATIONS

> > Import: Release 8.0.5.1.0 - Production on Wed Jan 24 13:50:36 2001

> > (c) Copyright 1998 Oracle Corporation.  All rights reserved.

> > Connected to: Oracle8 Enterprise Edition Release 8.0.5.1.0 -

 Production


> > With the Partitioning option

> > PL/SQL Release 8.0.5.1.0 - Production

> >

> > Export file created by EXPORT:V08.00.05 via conventional path

> > . importing FINANCE's objects into FINANCE

> > . . importing table                "GEM_RELATIONS"       1095 rows

 imported


> > About to enable constraints...

> > Import terminated successfully without warnings.

> >

> > $ SQLPlus sys/pwd

> > SQL*Plus: Release 8.0.5.0.2 - Production on Wed Jan 24 13:51:16 2001

> > (c) Copyright 1998 Oracle Corporation.  All rights reserved.

> > Connected to:

> > Oracle8 Enterprise Edition Release 8.0.5.1.0 - Production

> > With the Partitioning option

> > PL/SQL Release 8.0.5.1.0 - Production

> >

> > SQL> select owner,next_extent/1024 from dba_tables where

> > table_name='GEM_RELATIONS';

> >

> > OWNER                          NEXT_EXTENT/1024

> > ------------------------------ ----------------

> > FINANCE                                     168

> >

> > SQL> truncate table finance.gem_relations;

> >

> > Table truncated.

> >

> > SQL> select owner,next_extent/1024 from dba_tables where

> > table_name='GEM_RELATIONS';

> >

> > OWNER                          NEXT_EXTENT/1024

> > ------------------------------ ----------------

> > FINANCE                                     160

> >

> > --

> > Syltrem

> > http://pages.infinit.net/syltrem (OpenVMS Web Site)

> >

> >

>


> Query DBA_TABLES for the PCT_INCREASE value for the tables in

> question.  I would imagine that it is set to 5.

>


> --

> David Fitzjarrell

> Oracle Certified DBA

>
>


> Sent via Deja.com

> http://www.deja.com/