<vuht2000_at_yahoo.com> wrote in message
news:c9cd729c.0404251233.7757b85a_at_posting.google.com...
> Dear guys,
> I created a tablespace w/ this statement:
> CREATE TABLESPACE "DATA" LOGGING DATAFILE
> '/u02/oradata/AT/users01.dbf' SIZE 25M REUSE AUTOEXTEND ON NEXT
> 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT
> SPACE MANAGEMENT AUTO ;
>
> I later created a table:
> create table mytbl (id number, tag varchar2(20)) tablespace DATA;
>
> and filled it with ~1.6 million rows
> Then I found the following:
>
> select table_name, initial_extent, next_extent
> from dba_tables where table_name='mytbl';
>
> SEGMENT_NAME EXTENT_ID BYTES
> ---------------------------------
> mytbl 0 65536
> mytbl 1 65536
> mytbl 2 65536
> ...
> mytbl 15 65536
> mytbl 16 1048576
> mytbl 17 1048576
> ...
> mytbl 78 1048576
> mytbl 79 8388608
> mytbl 80 8388608
> ...
> mytbl 88 8388608
>
> 89 rows selected.
>
> I would expect the extent sizes increase by 50% as the default value
> of pct_increase, but could not explain why it keeps increasing in this
> pattern. Can anyone help me
> thanks,
> Tam
Why do you expect that? You said "Oracle, control the extent sizes for me."
So it is going to do so and is. One side note do you really want that
datafile to grow without bounds? I usually specify a max size that is the
same from file to file and won't take too long to get a file from tape. (eg
4 gigs/file)
Jim
Received on Sun Apr 25 2004 - 15:48:52 CDT
