Re: Maxextents = 2 billion?

From: Peter Sharman <psharman_at_us.oracle.com>
Date: Thu, 28 Jan 1999 15:52:55 -0800
Message-ID: <36B0F857.EE49154B@us.oracle.com>

Van

This value is what gets stored in the data dictionary when an object is created with MAXEXTENTS set to unlimited. True, it's not really unlimited, but hey, if you get that many extents you have a fragmentation issue to deal with!

HTH Pete

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

Regards

Pete

Peter Sharman                              Email: psharman_at_us.oracle.com
WISE Course Development Manager            Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education               (650)607 0109 (local)

San Francisco

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Thu Jan 28 1999 - 17:52:55 CST