Re: Question on Table space allocation

In article <34E46CC7.6D83_at_att.com>, Naren Chintala <naren_at_att.com> wrote:
>Hi,
>
>1. The db_block_size is 8k (8192 bytes).
>
>2. create table chk (c1 number) tablespace temp
>storage(initial 8k next 8k minextents 1 maxextents
>10 pctincrease 0);
>
>3. SELECT * FROM USER_EXTENTS where
>SEGMENT_NAME='CHK';
>
>SEGMENT_NAME = CHK
>SEGMENT_TYPE = TABLE
>TABLESPACE_NAME = TEMP
>EXTENT_ID = 0
>BYTES = 16384
>BLOCKS = 2
>
>Question:
>
>Why does Oracle allocate 2 blocks although the
>initial extent is set to 8k in the "Create table"
>statement?
>
>Having created a table with an initial extent of
>8k, I would expect to see 1 block and not 2.
>
>Thanks in advance for any help.
>Naren

Every segment consists of a minumum of two blocks since every segment starts with a segment header block. Received on Sat Feb 14 1998 - 00:00:00 CST