extent size issue

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 Received on Sun Apr 25 2004 - 15:33:20 CDT