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,
|
|
|
|
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 #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?
|
|
|
|
|
|
|
|