Home » RDBMS Server » Server Utilities » Improving the performance of Oracle Import
Improving the performance of Oracle Import [message #72060] Thu, 27 February 2003 23:32 Go to next message
manohar
Messages: 15
Registered: October 2001
Junior Member
Hi all

how to improve the performance of oracle imports
any resources (url,docs ) will be of some help

Manohar
Re: Improving the performance of Oracle Import [message #72061 is a reply to message #72060] Fri, 28 February 2003 05:37 Go to previous message
Remi Visser
Messages: 44
Registered: December 2002
Member
Hi

You can pass the buffer parameter. Increase it as far as you can. (I've experienced great results with it)

% imp system/manager ... buffer=3000000


Hope this helps

http://askremi.ora-0000.com
Previous Topic: field length issue
Next Topic: SQL*Loader Returns Error ORA-01461
Goto Forum:
  


Current Time: Tue May 14 21:09:49 CDT 2024