OraFAQ Forum: Server Utilities » import with buffer parameter

Home » RDBMS Server » Server Utilities » import with buffer parameter (Oracle 10.2.0.4 AIX 6L )

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

import with buffer parameter [message #488911]

Wed, 12 January 2011 03:55

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member

Hello Expert,

We are having daily syncing script which use to drop and import of one major schema.

When we do import with parameter BUFFER=209715200, it takes approximatively 4 hours & when we do without the parameter it takes 6 hours.

So i humbly request to please shed the light on the above scenario of import process with buffer parameter in concern.

Also to expose, import is done in freeze hours.

Thanks
Jay vardhan

Report message to a moderator

Re: import with buffer parameter [message #488912 is a reply to message #488911]

Wed, 12 January 2011 04:00

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

Senior Member
Account Moderator

IOs are more performant if you write less big ones than more small ones but you are nevertheless limited by your io subsytem performances.

Regards
Michel

Report message to a moderator

Re: import with buffer parameter [message #488923 is a reply to message #488912]

Wed, 12 January 2011 05:01

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member

thanks for the response. Very much clear.

Report message to a moderator

Previous Topic:	How to Export data based on Join between 3 tables.
Next Topic:	Alter The Status of Redolog

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 11:30:17 CST 2024