OraFAQ Forum: Server Utilities » Buffer in Parfile expdp

Home » RDBMS Server » Server Utilities » Buffer in Parfile expdp (Oracle 12c, windows)

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

Buffer in Parfile expdp [message #682253]

Tue, 13 October 2020 06:44

vbvyadav
Messages: 1
Registered: October 2020

Junior Member

I want to understand the need of a buffer value in a parfile for creating an export using expdp.

I have a parfile wherein the buffer value is set to 2000000.
The DBA suggested that i should double it to ensure there are no failures in export.

However, i want to know if this buffer value has a maximum limit? According to oracle docs, this is calculated by:
Rows_in_array * maximum_row_size.

Report message to a moderator

Re: Buffer in Parfile expdp [message #682254 is a reply to message #682253]

Tue, 13 October 2020 07:13

Michel Cadot
Messages: 68758
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

BUFFER parameter is ignored with "expdp".
With "exp" tool, it determines the size of the working buffer. The larger it is the lower is the number of IOs and network roundtrips, so better are the performances. If you have free client and server memory set it the higher you can, the default value is really really small.

[Updated on: Tue, 13 October 2020 10:05]

Report message to a moderator

Re: Buffer in Parfile expdp [message #682363 is a reply to message #682253]

Mon, 19 October 2020 11:49

Michel Cadot
Messages: 68758
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Any feedback?

Report message to a moderator

Previous Topic:	Oratop
Next Topic:	EXPDP error after recovering CONTROL and DATAFILES

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 06 07:32:01 CDT 2025