Re: MINEXTENTS > 1 ?

This is something you would do with parallel tables.

As I recall ( haven't done this lately ) the number of initial extents to create for a parallel table is ( 2 * degree_of_parallelism ).

The '2 * ' part could be wrong, and I'm sure someone will make a correction if it is, but parallel tables definitely require multiple initial extents.

On Mon, 1 May 2000, Walter K. wrote:

> When would you want to set MINEXTENTS to something other than '1' for a table? The only case I can think of is if I am trying to manually stripe a table/tablespace across multiple disks.
>
> Thanks.
> -w
>

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon
jkstill_at_bcbso.com - Work - preferred address jkstill_at_teleport.com - private Received on Mon May 01 2000 - 14:28:27 CDT