Re: Improve creation process of datafiles..

Hello ebuddelm

Yes we are in 9iR2, but the tablespace are dictionary managed, the database work with the "old" version of SAP 4.0, I read somewhere that the "add datafile" order could be parallelized, but checking the oracle doc about "alter tablespace" I didn't see this clause, the data are loaded in tablespace with import utility.

Thank yu

ebuddelm a écrit :

> 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 Thu Jan 26 2006 - 02:43:58 CST