Re: max extents

From: Damian Yenzi <yenzi_at_iserv.melpar.esys.com>
Date: Mon, 11 Apr 1994 12:18:48 GMT
Message-ID: <yenzi.766066728_at_melpar>


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
Received on Mon Apr 11 1994 - 14:18:48 CEST

Original text of this message