Re: max extents....

That limit was changed with 7.3. We now have UNLIMITED as a valid value for MAXEXTENTS.

It was debated here before wether it was a good idea to use that capacity. It revolves around the
strange idea that a DBA isnt interested in monitoring the growth of his/her databases. Although
the impact of 5 extents vs 500 extents on performance is, for some, a question of debate. I really
dont feel that I need UNLIMITED extents. I need to reorg once in a while, but that fine by me.

My 0.02$ worth :-)

By the way 121 is the limit for 2k block, 249 for 4k, etc.

Sylvain Leclerc
sleclerc_at_magrit

> -----Original Message-----
> From: Winnie Liu [SMTP:oracle_dba_at_zdnetmail.com]
> Posted At: Tuesday, October 20, 1998 2:01 AM
> Posted To: server
> Conversation: max extents....
> Subject: Re: max extents....
>
> I remember that the max extents is tied directly to the DB_block_size
> of
> your database.
>
> But I don't remember the value either. Can someone post it again?
>
> Winnie
>
> Tony Commander wrote in message <362B8D30.436671B0_at_enterprise.net>...
> >I'm sure I've read somewhere that the limit to a number of extents in
> >tables/indexes
> >has been raised/removed in a recent version of oracle ( we're running
> >7.3.4 on NT 4 )
> >from the old limit of 249.
> >
> >Is this my imagination or did I really read this somewhere a while
> ago?
> >
>
Received on Tue Oct 20 1998 - 08:03:38 CDT