Faster import export Oracle

For fast export
Set the buffer parameter to high value.
use direct=y
Set recordlength parameter to high.
Make sure on which on disk u r taking export should have minimal I/O.

For fast Import
Import without indexes then use the indexfile, due to which u can skip the creation of indexes at the time of import.
Increase the size of database buffer cache and log_buffer.
Keep database in no archive mode.
Use statistics=NONE and analyze=N in import command
Set the buffer parameter value to high
Use commit=y <- menurut sikathabis tergantung kebutuhan
Point the import dump file on different disk file other than database file disk.

links: http://all-about-oracle.blogspot.com/2006/10/faster-import-export.html

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: