Re: Disadvantage of Unlimited extent?

...And each extent entry has to be logged and maintained in the data dictionary. More overhead for no gain.

...And if those extents on blocksize * multi block read count boundaries, full table scan performance will be adversely affected.

MotoX.

MMK Productions wrote in message <6upgal$m0p_at_world6.bellatlantic.net>...
>I think the biggest disadvantage is that it allows for uncontrolled growth.
>The max extent error is really a big warning sign saying your sizing was
way
>off or an application piece is going out of control. Like auto-growing
data
>files, unlimited max extents can lull you into not monitor space stats only
>to find the errors you do eventually see are not so easily fixed.
>
>johnvue_at_gte.net wrote in message <6ug4da$ehd$1_at_news-2.news.gte.net>...
>>This is not really a "disadvantage" but just be aware -- the
>>documentation states that UNLIMITED extents don't apply to segments in
>>the SYSTEM tablespace.
>>
>>
>>On Fri, 25 Sep 1998 10:32:56 +0800, "Ng TC" <tcng_at_yas.com.sg> wrote:
>>
>>>Hi,
>>>
>>>Can anyone tell me what is the disadvantage of setting table extents to
>>>unlimited?
>>>
>>>Thanks in advance.
>>>
>>>Regards,
>>>Tse Chong
>>>
>>>Please reply to email:
>>>tcng_at_yas.com.sg
>>>
>>>
>>
>
>
Received on Tue Sep 29 1998 - 03:03:48 CDT