Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> extent size and segment size

extent size and segment size

From: Pauro Tanaka <syoujit_at_tsi.co.jp>
Date: 1997/01/23
Message-ID: <970123112403.M0120593@s_haiden1.tsi.co.jp>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US