Home » RDBMS Server » Server Utilities » import with buffer parameter (Oracle 10.2.0.4 AIX 6L )
import with buffer parameter [message #488911] Wed, 12 January 2011 03:55 Go to next message
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
Re: import with buffer parameter [message #488912 is a reply to message #488911] Wed, 12 January 2011 04:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: import with buffer parameter [message #488923 is a reply to message #488912] Wed, 12 January 2011 05:01 Go to previous message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

thanks for the response. Very much clear.
Previous Topic: How to Export data based on Join between 3 tables.
Next Topic: Alter The Status of Redolog
Goto Forum:
  


Current Time: Fri Mar 29 04:09:21 CDT 2024