Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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 DBAReceived on Fri Feb 24 2006 - 11:19:19 CST