OraFAQ Forum: Server Administration » What´s the maximum value of the parameter buffer ( export ) ?

Home » RDBMS Server » Server Administration » What´s the maximum value of the parameter buffer ( export ) ?

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

What´s the maximum value of the parameter buffer ( export ) ? [message #231044]

Fri, 13 April 2007 14:22

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

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

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

Littlefoot
Messages: 21818
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.

Report message to a moderator

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

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

Report message to a moderator

Previous Topic:	v$session - username, user#
Next Topic:	Server Name

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 23:42:03 CDT 2024