Home » RDBMS Server » Server Utilities » import - how to make it faster
import - how to make it faster [message #194138] Wed, 20 September 2006 23:20 Go to next message
oracledba_raja
Messages: 23
Registered: July 2006
Junior Member
Hi all,
Good Morning.
when import a .dmp file, how can make it faster?

Other than

igore = y

any specific approach?

Thanks.

Regards,
Raja
Re: import - how to make it faster [message #194149 is a reply to message #194138] Thu, 21 September 2006 00:26 Go to previous messageGo to next message
Shamsher
Messages: 18
Registered: September 2006
Junior Member

Use Commit=N if you can efford to, Larger tables may not be suitable for this option due to the required rollback/undo space.

Use sufficient buffer size for better performance;
Buffer=Nk

Use no index while importing by specifying Index parameter with no option insist of that can generate a Indexfile which you can run later to recreate all indexes.
Index=N

last but not lease recommended on your own risk _disable_logging = true oracle hidden parameter to reduce redo log generation but import will be not recoverable in case of failure.

Imp xyz/xyz@xyz file=xyz.dmp index=N buffer=750000 commit=N indexfile-xyz.txt




Thanks and Regards
Shamsheer
Re: import - how to make it faster [message #194219 is a reply to message #194138] Thu, 21 September 2006 04:03 Go to previous messageGo to next message
oracledba_raja
Messages: 23
Registered: July 2006
Junior Member
Thanks, Shamsheer.

Regards,
Raja
Re: import - how to make it faster [message #194349 is a reply to message #194219] Thu, 21 September 2006 10:49 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
In addition to what Shamsheer suggested, you may also want to consider setting STATISTICS=NONE. If you can't afford to disable the logging, then you could increase the size of your redo logs or for that matter if possible in your situation disable ARCHIVELOG.
Re: import - how to make it faster [message #194391 is a reply to message #194138] Thu, 21 September 2006 21:22 Go to previous message
oracledba_raja
Messages: 23
Registered: July 2006
Junior Member
Thanks, ebrian.

Regards,
Raja
Previous Topic: data migration from excel file to oracle 9i
Next Topic: exp on WIndows thru sqlplus
Goto Forum:
  


Current Time: Wed Dec 07 14:21:07 CST 2016

Total time taken to generate the page: 0.09990 seconds