impdp is not using parallelism (2 merged) [message #405458] |
Wed, 27 May 2009 22:37 |
rumman
Messages: 48 Registered: June 2007 Location: Bangladesh
|
Member |
|
|
impdp is not using parallelism:
impdp system/****@a directory=dp_t24 dumpfile=t24_20090523_postcob_%U.dmp schemas='T24' remap_schema='T24:T24TEST' REMAP_TABLESPACE=('GLOBUSDATAXML:GLOBUSTESTDATAXML','GLOBUSINDEXXML:GLOBUSTESTINDEXXML')
I exported the data using 8 parallism from IBM P5 server with AIX OS which took 6 hours.
Now, I am importing data in RHEL 4 with 8-cores machine. I set parallism 8, 16. But nmon report suggest only one processor is using at a time ( See attachement). It took 18 hours and only 19 percent is done.
Please give some suggestion.
|
|
|
|
|
|
Re: impdp is not using parallelism [message #405465 is a reply to message #405462] |
Wed, 27 May 2009 23:22 |
rumman
Messages: 48 Registered: June 2007 Location: Bangladesh
|
Member |
|
|
I am using version:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
And I stopped the job of impdp and then set parallelism 8, then 16.
But no result.
Any help pls.
|
|
|
Re: impdp is not using parallelism [message #405467 is a reply to message #405461] |
Wed, 27 May 2009 23:26 |
|
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
Mahesh Rajendran wrote on Wed, 27 May 2009 20:49 | Quote: | impdp system/****@a directory=dp_t24 dumpfile=t24_20090523_postcob_%U.dmp schemas='T24' remap_schema='T24:T24TEST' REMAP_TABLESPACE=('GLOBUSDATAXML:GLOBUSTESTDATAXML','GLOBUSINDEXXML:GLOBUSTESTINDEXXML')
|
In the posted snippet, where have you specified parallelism?
Either you are not telling us the whole story
or
my eyes are deceiving me.
|
rumman,
Please respond.
|
|
|