| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Maxextents = 2 billion?
Van Messner wrote:
>
> Hello Andy:
>
> Thanks to you and the others who answered. I thought that maxextents
> had a limit
> which was platform dependedent - 121 or 249 or whatever. Is this not true?
> If it is true
> how does Oracle treat a limit of 2 billion?
> In terms of crashing the server. Each time I tried to rebuild an index
> with one of the
> enormous limits, it crashed. Every other index rebuilt without any
> problems - none of them
> had maxextents set larger than 249.
>
> Van
>
> Andy Johnson wrote in message <36B14FFA.A3933EB7_at_accesscom.net>...
> >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
> >
> >
Maxextents used to be dependent on block size - different block sizes gave the 121, 249 etc limits you are refering to...
From 7.3 you have "maxextents unlimited" as an option...although 2 billion might be considered a little high (by about 1.99999 billion)
Cheers
--
 |
 |