| 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.
|
|
|
|
| Re: Buffer in Parfile expdp [message #682254 is a reply to message #682253] |
Tue, 13 October 2020 07:13  |
 |
Michel Cadot
Messages: 68733
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
