Re: Why is NEXT_EXTENT changing all the time?

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/