Extent allocations are made in a number of blocks that round upto 5. Even if
you do specify an explicit allocation.
Sybrand Bakker wrote in message
<947839808.25667.0.pluto.d4ee154e_at_news.demon.nl>...
>AFAIK everything is rounded to a multiple of 5 blocks. Probably only when
>you don't specify any explicit allocation
>as you did in your create table as select statement. I have no database at
>hand currently, so I can't investigate.
>
>Hth,
>
>--
>Sybrand Bakker, Oracle DBA
>kor <kor.g_at_hetnet.nl> wrote in message news:OuGowomX$GA.150_at_net003s...
>> Hi everyone
>> >
>> > I can't understand the following difference
>> >
>> > i have a tablespace with default storage :
>> >
>> > TABLESPACE_NAME INITIAL_EX NEXT_EXTEN MIN_EXTENT
>MAX_EXTENT
>> > PCT_INCREA STATUS CONTENTS
>>
>> ------------------------------ ---------- ---------- ---------- ---------
-
>> > ---------- --------- ---------
>> > ONTWHOREN_DATA_SMALL 131072 131072 1
>1024
>> > 0 ONLINE PERMANENT
>> >
>> > When i create a table when no storage clause
>> >
>> > SQL> CREATE TABLE ONTWHOREN.TEST AS SELECT * FROM APPL_GEBR;
>> >
>> > Table created.
>> >
>> > SQL>
>> >
>> > then i query the dba_segments view :
>> >
>> > OWNER SEGMENT_NAME TABLESPACE_NAME
>BYTES
>> > BLOCKS INITIAL_EX EXTENTS
>> > ----------------- ------------------- ------------------------------
>> > ---------- ---------- ---------- ----------
>> > ONTWHOREN TEST ONTWHOREN_DATA_SMALL
>> > 143360 35 131072 1
>> >
>> >
>> >
>> > I see a difference off 3 oracle blocks (db_block_size = 4096);
>> > instead of the 32 blocks i expected there are 35 blocks.
>> >
>> > anyone with a logical explanation ?
>> >
>> > thanks
>> >
>> > g.kor
>> > rdw vehicle administration
>> > the netherlands
>> > gkor_at_rdw.nl
>> >
>>
>>
>>
>
>
Received on Fri Jan 14 2000 - 05:51:04 CST
