Re: max extents

In article <yenzi.766066728_at_melpar>, yenzi_at_iserv.melpar.esys.com (Damian Yenzi) writes:
|> barry.roomberg_at_compudata.com (Barry Roomberg) writes:
|>
|> >-> Is there a way to increase the maxextents for a tablespace?
|> >-> Currently, the largest value I can enter for one is 249.
|> >-> I am using oracle 7 on aix 3.2.3.
 

|> >I seem to recall that this is a function of block size.
|> >Try creating a new oracle instance, double block size, and see how many
|> >extents a table can be.
 

|> >Performance will probably go up if you hardware can handle the larger
|> >blocks.
 

|> >you may end up re-creating your current system.
|>
|> Block size affects max extents in the following:
|> 1k -> 57 extents
|> 2k -> 121
|> 4k -> 249

General : block size of X k gives ((64 * X) - 7) extents ....

		Tom Losnedahl, NODECA, Oslo, Norway
		Tom.Losnedahl_at_nodeca.mil.no