OraFAQ Forum: Backup & Recovery » Exp/Imp ,Max Buffer size value

Home » RDBMS Server » Backup & Recovery » Exp/Imp ,Max Buffer size value

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

Exp/Imp ,Max Buffer size value [message #249234]

Tue, 03 July 2007 13:12

harry07
Messages: 61
Registered: June 2007
Location: now york

Member

Hey

I have read that using BUFFER SIZE parameter with exp/imp you can gearup the process..

But the question in mind is how much BUFFER SIZE can i give??

does it effect the database performance?

Can somebody help me please

regards

Thanks in Advance

Report message to a moderator

Re: Exp/Imp ,Max Buffer size value [message #249235 is a reply to message #249234]

Tue, 03 July 2007 13:16

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Might the answer depend upon
OS name & version (which you don't specify)
Oracle version (which you don't specify)
Amount of vailable RAM (which you don't specify)

What prevents you from doing your own benchmarking to answer your own question?

Report message to a moderator

Re: Exp/Imp ,Max Buffer size value [message #249236 is a reply to message #249234]

Tue, 03 July 2007 13:20

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I often use 100000000.

Regards
Michel

Report message to a moderator

Re: Exp/Imp ,Max Buffer size value [message #249237 is a reply to message #249234]

Tue, 03 July 2007 13:24

harry07
Messages: 61
Registered: June 2007
Location: now york

Member

Thanks for your Reply and
Sorry that i did not give you the details

-bash-3.00$ cat /etc/issue
Red Hat Enterprise Linux ES release 4 (Nahant Update 5)
Kernel \r on an \m

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 3 19:40:46 2007

-bash-3.00$ grep "MemTotal" /proc/meminfo
MemTotal: 1034060 kB

Thanks

Report message to a moderator

Re: Exp/Imp ,Max Buffer size value [message #249239 is a reply to message #249236]

Tue, 03 July 2007 13:34

harry07
Messages: 61
Registered: June 2007
Location: now york

Member

Thanks Michel for reply

Can you tell me on what basis you see that how much buffer_size can you set .Does it depend on RAM or some other parameters

Is it like that buffer has to be in the range of SOMETHING.

Report message to a moderator

Re: Exp/Imp ,Max Buffer size value [message #249240 is a reply to message #249239]

Tue, 03 July 2007 13:45

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I have free RAM enough when I do that.

Regards
Michel

Report message to a moderator

Previous Topic:	SVRMGRL
Next Topic:	excluding tablespace from flashback database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 14 14:42:54 CDT 2024