Re: Improve creation process of datafiles..

On Wed, 25 Jan 2006 21:17:43 +0100, "Sylvestre" <Sylvestre_at_world.com> 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
>

It is not possible to parallelize this operation, as the first statement will result in a DDL lock.
The best thing you can probably do is just don't create them on cooked disks (ufs, veritas) but on RAW filesystems. As far as I know Oracle does still overwrite all bytes in the datafile with F6 (hex), and I bet they don't do this on RAW.

--
Sybrand Bakker, Senior Oracle DBA