Re: Maxextents = 2 billion?

The more probable guess is that they are using the unlimited max extents option which will uses that number as the value.

I don't think multiple extents are a very big problem unless they are especially small - or unless you are talking about thousands of extents.

I would look into why the system is crashing on an index rebuild though.

Hope this helps
Marcus Anthony

Van Messner <vmessner_at_netaxis.com> wrote in message news:QC5s2.145$q27.120_at_news14.ispnews.com...
> 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
>
>
Received on Thu Jan 28 1999 - 18:21:44 CST