Impdp so slow [message #357356] |
Wed, 05 November 2008 00:50 |
supportx2008
Messages: 13 Registered: May 2008
|
Junior Member |
|
|
Is it normal to import a dump of 40M data into a clean schema for 17 minutes ?
The command we use is
impdp user/password@ORADB DIRECTORY=EXPORTDP DUMPFILE=TEST.DUMP LOGFILE=TEST1.log SCHEMAS=SCHONE REMAP_SCHEMA=SCHONE:SCHTWO EXCLUDE=STATISTICS
No. of tables : 1300
Anyway to tune ?
|
|
|
|
|
Re: Impdp so slow [message #357469 is a reply to message #357356] |
Wed, 05 November 2008 08:17 |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
Do any of the tables have a LONG datatype?
Is the database on the same server? Importing across is network is very slow.
|
|
|
Re: Impdp so slow [message #357565 is a reply to message #357469] |
Wed, 05 November 2008 19:17 |
supportx2008
Messages: 13 Registered: May 2008
|
Junior Member |
|
|
joy_division:
The schema do not have the LONG datatype. The dump file is on the same server.
Michel Cadot:
Any trace/log file that I could check for the bottleneck of the impdp ? I also try to enlarge the sga but it doesn't help.
Besides, how long would it take normally for importing 40M schema with data ?
|
|
|