| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Mailing Lists -> Oracle-L -> Locally managed tablespaces + auto-allocate
I created this table in a locally managed (auto-allocate) tablespace:
create table testext ( c1 char (250)) storage (initial 10M next 10M) tablespace dimd;
When I query the extents:
select * from user_extents where segment_name = 'TESTEXT';
SEGMENT_NA PARTITION_ SEGMENT_TYPE TABLESPACE_NAME EXTENT_ID BYTES
BLOCKS
---------- ---------- ------------------ --------------- --------- ---------
TESTEXT TABLE DIMD 0 1048576 64 TESTEXT TABLE DIMD 1 1048576 64 TESTEXT TABLE DIMD 2 1048576 64 TESTEXT TABLE DIMD 3 1048576 64 TESTEXT TABLE DIMD 4 1048576 64 TESTEXT TABLE DIMD 5 1048576 64 TESTEXT TABLE DIMD 6 1048576 64 TESTEXT TABLE DIMD 7 1048576 64 TESTEXT TABLE DIMD 8 1048576 64 TESTEXT TABLE DIMD 9 104857664
10 rows selected.
WHY DOES IT HAVE TO SPLIT THE EXTENT TO MANY SMALL ONES? Received on Tue Oct 10 2000 - 12:16:44 CDT
![]() |
![]() |