Maxextents = 2 billion?

    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 - 16:30:42 CST