system tablespace extents question

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 24 Jul 2002 16:40:22 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA70269BAF9@lnewton.leeds.lfs.co.uk>

Jan,

>> This is what I thougth in the first place, too. It should be very
easy to
>> understand.
>> But:
>> If the extent default size in the tablespace is 100k, and a table is
created
>> with 1M extent size,
>> does this mean, that after some filled extents of 100k in the
tablespace,
>> one 1M extent may follow,
>> and after it, again several 100k extents - so that the row of extents
may
>> have *different sizes* ?

It sure does and leads to free space fragmentation. Have a look here :

http://www.jlcomp.demon.co.uk/faq/RclmFreeSpace.html

for more information on the subject.

>> I love this group ! It provides a lot of help -

It sure does :o)

Regards,
Norman.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

Received on Wed Jul 24 2002 - 10:40:22 CDT