Re: Parallel Database Import / Export

From: Tanel Poder <tanel_at_@peldik.com>
Date: Wed, 2 Jul 2003 01:47:04 +0300
Message-ID: <3f020f75$1_1@news.estpak.ee>

Hi!

IO might become even bigger bottleneck when you are doing your exp/imp from segments on same disks.
But if your segments reside on different disks, or IO is very fast compared to your CPUs, then it's worth trying.

Another thing is, you could do index creation in parallel after data is loaded..

Tanel.

"Will Greene" <wgreene_at_ts.checkpoint.com> wrote in message news:3f01f1e7_2_at_Usenet.com...
> Hello,
> I was wondering if there was a way to perform a multiple database
> import to improve performance on a dual cpu Solaris box? I am guessing
that
> I could manually select the tables to export into two separate dmp files.
> Will I gain any performance or will the i/o still be the bottleneck during
> the import?
>
> Thanks,
> Will
>
>
>
> Posted Via Usenet.com Premium Usenet Newsgroup Services
> ----------------------------------------------------------
> ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
> ----------------------------------------------------------
> http://www.usenet.com
Received on Tue Jul 01 2003 - 17:47:04 CDT