Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Disadvantage of Unlimited extent?
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 Mon Sep 28 1998 - 21:22:53 CDT