Home » RDBMS Server » Backup & Recovery » BUFFER Parameter
BUFFER Parameter [message #220194] Mon, 19 February 2007 07:26 Go to next message
gajini
Messages: 262
Registered: January 2006
Senior Member


Hi,

What is the importance of export and import "BUFFER" parameter,
how it helps in improving the performance of Export and Import
utilities?

Regards,
Gajini
Re: BUFFER Parameter [message #220200 is a reply to message #220194] Mon, 19 February 2007 07:46 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
It is improve time for IMPORT/EXPORT operation.

BUFFER size of data buffer
default values for BUFFER parameters is 4 KB.


also go through for matrix about BUFFER parameter.

http://www.dba-oracle.com/oracle_tips_load_speed.htm

Also see Metalink Note 155477.1


regards
Taj
Previous Topic: Restore 8 to 10
Next Topic: Backup error RMAN-03009
Goto Forum:
  


Current Time: Thu May 02 12:48:38 CDT 2024