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

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@ts.checkpoint.com> wrote in message
news:3f01f1e7_2@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