Home » RDBMS Server » Server Utilities » Impdp so slow (Window 2003 Oracle 10g RAC (10.2.0.3))
Impdp so slow [message #357356] Wed, 05 November 2008 00:50 Go to next message
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 #357357 is a reply to message #357356] Wed, 05 November 2008 00:52 Go to previous messageGo to next message
supportx2008
Messages: 13
Registered: May 2008
Junior Member
Forget to state the configuration

Oracle 10g RAC (10.2.0.3)
Windows 2003 Server
Re: Impdp so slow [message #357366 is a reply to message #357356] Wed, 05 November 2008 01:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Investigate your server and instances to know where the bottleneck is.

Regards
Michel
Re: Impdp so slow [message #357469 is a reply to message #357356] Wed, 05 November 2008 08:17 Go to previous messageGo to next message
joy_division
Messages: 4640
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 Go to previous message
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 ?
Previous Topic: export of 10g Database using 9i client throwing "Segmentation Fault (core dumped)"
Next Topic: SQL Loader, CTL file: How to DEFAULT a value ?
Goto Forum:
  


Current Time: Tue Dec 06 10:17:04 CST 2016

Total time taken to generate the page: 0.12021 seconds