max extents
From: Barry Roomberg <barry.roomberg_at_compudata.com>
Date: Sat, 9 Apr 94 14:58:00 -0500
Message-ID: <12a.634.905.0N3E0F0B_at_compudata.com>
Date: Sat, 9 Apr 94 14:58:00 -0500
Message-ID: <12a.634.905.0N3E0F0B_at_compudata.com>
-> 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. Received on Sat Apr 09 1994 - 21:58:00 CEST