Re: Improve creation process of datafiles..

Hi Sylvestre,

If you initially create small datafiles the creation will be faster. However the adding of new extents to the datafiles if you add the auto extend option will require time as well. And probably more time than when you create the datafiles with the right size. But you may not notice this because I suspect the overhead of adding extents may be negligeble compared to the time the adding of the actual data must take (1TB). You might consider a large extent size for the datafiles so you don't have them extended too often.
BTW I presume that this is a locally managed tablespace in 9i.

Kind regards,
Eric.

Sylvestre wrote:
> Hello
>
> It is asked to me to reduce the time of creation
> of datafiles during a reorg:
> some tablespace are created with 50 datafiles of
> 20 Gig, Is it possible to parallelize
> this operation ? or is it better to create them
> with less space, 1Gig, and to put
> them autoextend on ? during the reorganisation all
> the datafile are filled with data
> so we need all the 50X20Gig...
>
> Thank yu
Received on Wed Jan 25 2006 - 15:15:39 CST