Re: Maxextents = 2 billion?

Van Messner wrote:

> I started work at a site with ten out of tune instances. I was looking
> for objects which had thrown extents and found more than a thousand with
> over 50 extents each.
> As I started to look at the worst of them I discovered ten had
> maxextents set to 2.nnnE+09. I was surprised that Oracle accepted a value
> this high. Can anyone explain why this is allowed?
> Trying to rebuild these indexes resulted in a server crash for each
> attempt. I ended up dropping them and making new ones.
> My guess is that someone was entering storage parameters for maxextents
> = 249 and hit the "e" key which is just below the "4" key.
>
> Thanks for any info
>
> Van

When a table is created with maxextents unlimited, the number is actually set to 2^31, so, no, it's not a mistake, just bad practice. I usually set mine to 200, so at least if something breaks and starts using space like crazy it won't use all of it before I can fix it. I have some automated apps (third party) that do this once a blue moon (actually, the next blue moon is this weekend, so I have a lot to look forward to).

Andy Johnson Received on Fri Jan 29 1999 - 00:06:50 CST