Re: Yet, another Extent question ?

Spreading a table over multiple disks is not yet that effective in Oracle, as you cannot control which data goes into which extent (disk). MinExtents is most useful when you need to create a large table, but you do not have a large contiguous free space. You can specify an initial (smaller) extent size and minextents > 1 to allocate multiple extents, which together consume a large amount of free space, but not in one extent.

>hi,
>1- MIN and MAX extents can be used to spread the table over several
> disk (use MIN at creation), and control (if you dont want
> more than a given number of extents.
>2- Surely you can use this method, but beware of extra space that
> oracle needs for table management (i.e. in computing the size of
> your tables.
>
>hth
>
Received on Sun Aug 27 1995 - 00:00:00 CEST