Home » RDBMS Server » Server Utilities » recordlength & buffer parameter in IMP (oracle 10g)
recordlength & buffer parameter in IMP [message #393671] Tue, 24 March 2009 01:06 Go to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
In IMPORT of oracle we specify 2 parameter
1. recordlength
2. buffer

1. How much maximum size we can spercify for those parameter to fasten the IMPORT process? Also on which thing those values depends?

2. Also how much time will it save if we specify those parameters? e.g. If any IMPORT takes 10 Hours to import and if we specify those 2 parameters to high values then how much will it take to import?

3. Is there any other parameter which will fasren the import process?

Thanks,
Re: recordlength & buffer parameter in IMP [message #393675 is a reply to message #393671] Tue, 24 March 2009 01:14 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
1. How much maximum size we can spercify for those parameter to fasten the IMPORT process? Also on which thing those values depends?

1 gazillion percent

2. Also how much time will it save if we specify those parameters? e.g. If any IMPORT takes 10 Hours to import and if we specify those 2 parameters to high values then how much will it take to import?

5


3. Is there any other parameter which will fasren the import process?

_make_import_faster=true
Re: recordlength & buffer parameter in IMP [message #393676 is a reply to message #393675] Tue, 24 March 2009 01:21 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Thanks for your reply.

1. Still some queries.
Quote:
1 gazillion percent


I do not understand this. As per my database how can check the max value for recordlength & buffer parameter.

2.
Quote:
Also how much time will it save if we specify those parameters? e.g. If any IMPORT takes 10 Hours to import and if we specify those 2 parameters to high values then how much will it take to import?

5


Does it really reduces to 5 hours?

3.
Quote:
_make_import_faster=true

SQL> show parameter make_import_faster
SQL> show parameter import
SQL> show parameter faster
SQL>
there is no parameter in oracle?

Thanks,

[Updated on: Tue, 24 March 2009 01:35] by Moderator

Report message to a moderator

Re: recordlength & buffer parameter in IMP [message #393682 is a reply to message #393676] Tue, 24 March 2009 01:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Let me summarize BlackSwan's.

1+2) Measures depend on your environment, so you have to make test on your environment
3) All (Oracle) parameters are described in the documentation

Regards
Michel
Re: recordlength & buffer parameter in IMP [message #393688 is a reply to message #393671] Tue, 24 March 2009 01:45 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Quote:
1+2) Measures depend on your environment, so you have to make test on your environment


Please explain what u mean depend on your environment?

That is my question what thing i need to check so that i can specify largest values to fasten the IMP process.
And how can i calcuate the highest values for both?

Can i specify it recordlength=65535 buffer=200000 randomly?
Re: recordlength & buffer parameter in IMP [message #393690 is a reply to message #393688] Tue, 24 March 2009 01:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Please explain what u mean depend on your environment?

Memory, IO, CPU, OS, concurrent workload...

Quote:
And how can i calcuate the highest values for both?

Benchmark on your environment, see above.

Regards
Michel
Re: recordlength & buffer parameter in IMP [message #393697 is a reply to message #393671] Tue, 24 March 2009 01:55 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
I am confused Smile
Please just let me know can i use
recordlength=65535 buffer=200000

or other higher vaulues also works better?

Thanks,
Re: recordlength & buffer parameter in IMP [message #393701 is a reply to message #393697] Tue, 24 March 2009 01:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is not clear in my answer: the values you can use depend on your environment.

So the answer to your question is: yes, no, maybe.

Regards
Michel
Re: recordlength & buffer parameter in IMP [message #393728 is a reply to message #393701] Tue, 24 March 2009 03:21 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Quote:
3. Is there any other parameter which will fasren the import process?

_make_import_faster=true


I think this is NOT good advice to touch hidden parameters.

@ora_2007

http://www.orafaq.com/wiki/Import_Export_FAQ#How_can_one_improve_Import.2F_Export_performance.3F

Babu

[Updated on: Tue, 24 March 2009 03:23]

Report message to a moderator

Re: recordlength & buffer parameter in IMP [message #393731 is a reply to message #393728] Tue, 24 March 2009 03:27 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
gentlebabu wrote on Tue, 24 March 2009 09:21
Quote:
3. Is there any other parameter which will fasren the import process?

_make_import_faster=true


I think this is NOT good advice to touch hidden parameters.



./fa/449/0/

[Updated on: Tue, 24 March 2009 03:27]

Report message to a moderator

Previous Topic: How to write import scripts in batch file
Next Topic: how to import .csv file into oracle database using a not null column
Goto Forum:
  


Current Time: Sun Dec 04 10:49:59 CST 2016

Total time taken to generate the page: 0.08697 seconds