>
> I searched your web page for an answer but couldn't find it. I have read
> in a number of places that the hard-coded limit for number of extents is
> 249 if block size is 4k and 505 is blocksize is 8k. However, I see, in
> our database, examples where the number of extents have exceeded this
> limit. For example, our database is 4k blocksize but I find extents over
> 300. What am I missing?
>
> Thanks.
>
> Glenn Wiens
> Celeritas Technologies, LLC
> wiens@celeritas.net
> gwiens@dtc.net
>
Glenn,
The limit that you describe is the default limit. In Oracle 7.3 and versions
above, you can specify MAXEXTENTS UNLIMITED which is just that - unlimited.
Unless you specify UNLIMITED, then you will still be bound by the numbers
you list above (121 extents for a 2K block size as well).
Best regards,
-Ari Kaplan
Independent Oracle DBA Consultant
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 245+ Oracle tips, visit my Web Page: <->
<-> <->
<-> www.arikaplan.com <->
<-> <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Back to Ari Kaplan's Home Page