Re: creating tablespaces in parallel

Hi,

     It all depends on your disk layout,disk heads,and the selection of jobs.CPU

     criteria might be secondary.
     If they are independent disks,It might help to start jobs in
     parallel which do not write to the same disk.Again if you have only 2
controllers
     it might be best to limit the jobs to 2.
     If they are in a RAID config and striped out at 
     different levels,I feel (though I may be wrong) that it is best to let
them go sequentially
     to avoid any possible contention.
     Hope this helps.

Madhusudhan Nunna <nunna_at_apple.vin.bellcore.com> wrote in article <667fbp$69j_at_athos.cc.bellcore.com>...
> 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.
>
>
>
>
>
>
Received on Tue Dec 09 1997 - 00:00:00 CST