Re: max extents....

From: <satar_at_my-dejanews.com>
Date: Tue, 20 Oct 1998 23:22:41 GMT
Message-ID: <70j601$nam$1@nnrp1.dejanews.com>

First off, if your table has more than 100 extents, you must suck as a DBA in regards to tuning. Second, there is no limit on the number of extents on the Oracle End. On the hardware level, well...that's a different story!

Satar

In article <362C38B0.CEBB74BF_at_bph.krakow.pl>, Sebastian Bienkiewicz <bienkiew_at_bph.krakow.pl> wrote:
> Each next db_block_size value doubles max extents parameter + few
> extents for a header
>
> Winnie Liu wrote:
> >
> > 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?
> > >
>
> --
> no signature
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Oct 20 1998 - 18:22:41 CDT