Home » RDBMS Server » Server Administration » What´s the maximum value of the parameter buffer ( export ) ?
What´s the maximum value of the parameter buffer ( export ) ? [message #231044] Fri, 13 April 2007 14:22 Go to next message
Ivancleber da Silva Neves
Messages: 74
Registered: July 2002
Member
What's the maximum value of the parameter buffer ( export ) ? Recordlength is 65535.

Thanks in advance
Re: What´s the maximum value of the parameter buffer ( export ) ? [message #231069 is a reply to message #231044] Fri, 13 April 2007 23:29 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
1.default values for BUFFER and RECORDLENGTH parameters are 4 KB and 2 KB respectively.


If we notice buffer parameter default value is just double of RECORDLENGTH parameter.. so you can specify double of recordlength.

Regards
Taj
Re: What´s the maximum value of the parameter buffer ( export ) ? [message #231078 is a reply to message #231044] Sat, 14 April 2007 00:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know if there is a maximum value for buffer but actualy it mainly depends on your memory.
I often used 100MB.

Regards
Michel
Re: What´s the maximum value of the parameter buffer ( export ) ? [message #231126 is a reply to message #231078] Sat, 14 April 2007 13:35 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This is Oracle Documentation page which talks about Export and Import utilities. Search for the BUFFER keyword and read more about it.
Re: What´s the maximum value of the parameter buffer ( export ) ? [message #231127 is a reply to message #231126] Sat, 14 April 2007 13:48 Go to previous message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
For conventional path exports, a larger buffer will increase the number of rows that are processed between each physical write to the export file. Fewer physical writes equals greater performance. The following formula can be used to determine a proper buffer size

buffer size = rows in array * max row size

But it's OS dependent.

Regards,
Harsh
Previous Topic: v$session - username, user#
Next Topic: Server Name
Goto Forum:
  


Current Time: Wed Dec 07 04:46:16 CST 2016

Total time taken to generate the page: 0.06081 seconds