Hi,
I created a table with the following specification and bulk loaded about 106,369,275 records into it.
create table test
(col_1 varchar2(32 byte),
col_2 varchar2(4 byte),
col_3 number(19,3),
col_4 number(19,3),
col_5 varchar2(10 byte),
col_6 varchar2(35 byte)
)
tablespace HOME_DB
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
);
Now when I look into USER_EXTENTS I see that different extents are of different sizes. Here are some of the columns from the USER_EXTENTS table
| Segment Name | Partition Name | Tablespace Name | Extent ID | Bytes | Blocks |
| TEST | | HOME_DB | 0 | 65536 | 8 |
| TEST | | HOME_DB | 1 | 65536 | 8 |
| TEST | | HOME_DB | 77 | 1048576 | 128 |
| TEST | | HOME_DB | 79 | 8388608 | 1024 |
| TEST | | HOME_DB | 84 | 7340032 | 896 |
Now I have two questions
1. Why is there an extent id of 1 with a value of 64k. Should not only the initial extent of 0 be of size 64k?
2. Why are the extent sizes different? Should not they all be 1M after initial extent?
I am really new to these concepts so it would be great if you people could suggest.
Thanks