Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: creating tablespaces in parallel
nunna_at_apple.vin.bellcore.com (Madhusudhan Nunna) wrote:
>Hello Oracle folks,
> Did anyone face the problem of creating a 500GB database
>in less than a day? Well I did and tried the obvious option of creating
>tablespaces in parallel, by running multiple server manager sessions.
>I'am trying this with oracle 7.3.2.3 on a HP-UX11 machine with 16 CPUs.
>But I'am not seeing the expected improvement in tablespace creation timings.
>It is still taking as much time as it would take if they were to be created
>sequentially.
>
> Can anyone throw some light on this issue? I'am sure many
>others must have faced a similar scenario.
>
>Thanks in advance,
>Madhu Nunna
>Bell Communications Research.
>
Oracle will serialize all CREATE TABLESPACE commands. Received on Fri Dec 05 1997 - 00:00:00 CST