OraFAQ Forum: Server Utilities » recordlength & buffer parameter in IMP

Home » RDBMS Server » Server Utilities » recordlength & buffer parameter in IMP (oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

recordlength & buffer parameter in IMP [message #393671]

Tue, 24 March 2009 01:06

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,

Report message to a moderator

Re: recordlength & buffer parameter in IMP [message #393675 is a reply to message #393671]

Tue, 24 March 2009 01:14

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: recordlength & buffer parameter in IMP [message #393676 is a reply to message #393675]

Tue, 24 March 2009 01:21

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

Michel Cadot
Messages: 68647
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

Report message to a moderator

Re: recordlength & buffer parameter in IMP [message #393688 is a reply to message #393671]

Tue, 24 March 2009 01:45

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?

Report message to a moderator

Re: recordlength & buffer parameter in IMP [message #393690 is a reply to message #393688]

Tue, 24 March 2009 01:49

Michel Cadot
Messages: 68647
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

Report message to a moderator

Re: recordlength & buffer parameter in IMP [message #393697 is a reply to message #393671]

Tue, 24 March 2009 01:55

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,

Report message to a moderator

Re: recordlength & buffer parameter in IMP [message #393701 is a reply to message #393697]

Tue, 24 March 2009 01:59

Michel Cadot
Messages: 68647
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

Report message to a moderator

Re: recordlength & buffer parameter in IMP [message #393728 is a reply to message #393701]

Tue, 24 March 2009 03:21

babuknb
Messages: 1736
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

Michel Cadot
Messages: 68647
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.

[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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Apr 28 19:20:32 CDT 2024