Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> extent size and segment size
The size of the initial extent differs from user_segment(view) shows. Please tell me why.
SQL> create table a ( a char(1) ) storage ( initial 101k );
[table was created](Japanese local message)
SQL> select * from user_segments;
SEGMENT_NAME
SEGMENT_TYPE TABLESPACE_NAME BYTES BLOCKS ----------------- ------------------------------ ---------- ----------
EXTENTS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE
---------- -------------- ----------- ----------- ----------- ------------
FREELISTS FREELIST_GROUPS
---------- ---------------
A
TABLE SYOUJIT 122880 30 1 106496 8192 1 249 0 1 1
Page size is 4K.
I can understand that 'INITIAL_EXTENT' is changed from 101k to 104k(106496bytes)
But I can't understand that 'BYTES' shows 122880 bytes ( 120k ).
Received on Thu Jan 23 1997 - 00:00:00 CST