Home » RDBMS Server » Server Utilities » Buffer in Parfile expdp (Oracle 12c, windows)
Buffer in Parfile expdp [message #682253] Tue, 13 October 2020 06:44 Go to next message
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.

Re: Buffer in Parfile expdp [message #682254 is a reply to message #682253] Tue, 13 October 2020 07:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Any feedback?

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


Current Time: Thu Mar 28 08:25:25 CDT 2024