11gR2 Data Pump question - parallel setting
From: CRISLER, JON A <JC1706_at_att.com>
Date: Thu, 26 Jul 2012 22:14:14 +0000
Message-ID: <9F15274DDC89C24387BE933E68BE3FD3347EF4_at_MISOUT7MSGUSR9D.ITServices.sbc.com>
Is there any benefit to setting a Data Pump import to parallel=12 if the export was run with parallel=8 ? It seems to accept higher values, and spawns 12 workers. My goal is to get the items like index creation, constraints etc. to run faster. The source system has 8 cpu's, the target system 24 cpus.
Date: Thu, 26 Jul 2012 22:14:14 +0000
Message-ID: <9F15274DDC89C24387BE933E68BE3FD3347EF4_at_MISOUT7MSGUSR9D.ITServices.sbc.com>
Is there any benefit to setting a Data Pump import to parallel=12 if the export was run with parallel=8 ? It seems to accept higher values, and spawns 12 workers. My goal is to get the items like index creation, constraints etc. to run faster. The source system has 8 cpu's, the target system 24 cpus.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 26 2012 - 17:14:14 CDT