ralph_rea
asked on
Oracle EXPDP - IMPDP
Hi,
Oracle version: 10g
O.S: Windows 2003
I've 2 oracle instance: ORCL1 (schema TOM) on machine1 and ORCL2 (schema SAM) on machine2
I'd like to import the schema TOM into schema SAM.
TOM schema size is 300 GB
I exported TOM with following parfile:
Now I need import into schema SAM, but I'd like to import faster
Which parameter can I add at following imp parfile to speed up the import?
Thanks in advance!
Oracle version: 10g
O.S: Windows 2003
I've 2 oracle instance: ORCL1 (schema TOM) on machine1 and ORCL2 (schema SAM) on machine2
I'd like to import the schema TOM into schema SAM.
TOM schema size is 300 GB
I exported TOM with following parfile:
SCHEMAS=TOM
DIRECTORY=TOM_DIR
DUMPFILE=exp_tom_%U.dmp
LOGFILE=exp_tom.log
filesize=30GB
JOB_NAME=EXP_JOB
and created about 10 dump files in more of 30 hoursNow I need import into schema SAM, but I'd like to import faster
Which parameter can I add at following imp parfile to speed up the import?
schemas=TOM
remap_schema=TOM:SAM
logfile=imp_sam.log
directory=SAM_DIR
DUMPFILE=exp_tom_%U.dmp
exclude=statistics
job_name=IMP_JOB
Thanks in advance!
ASKER
yes, but impdp write to the different disks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
my oracle version: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0
in impdp I used FILESIZE parameter. Can I use PARALLEL parameter for expdp speed?
schemas=TOM
remap_schema=TOM:SAM
logfile=imp_sam.log
directory=SAM_DIR
DUMPFILE=exp_tom_%U.dmp
exclude=statistics
job_name=IMP_JOB
PARALLEL=4
in impdp I used FILESIZE parameter. Can I use PARALLEL parameter for expdp speed?
schemas=TOM
remap_schema=TOM:SAM
logfile=imp_sam.log
directory=SAM_DIR
DUMPFILE=exp_tom_%U.dmp
exclude=statistics
job_name=IMP_JOB
PARALLEL=4
certainly, and good catch :)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
what is your SGA set to in the init.ora file ?
select name, value, display_value from v$parameter
where name in ('sga_max_size', 'sga_target');
how much physical memory do you have on your server ?
if your sga_size is very close or bigger than your physical memory then your server will be paging all the time >> slow performance
select name, value, display_value from v$parameter
where name in ('sga_max_size', 'sga_target');
how much physical memory do you have on your server ?
if your sga_size is very close or bigger than your physical memory then your server will be paging all the time >> slow performance
does the expdp write to the same disks as where the database files reside?