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