pengetahuan, tv, sepakbola, Indonesia, film, selebritis, koran, games, kehidupan, paparazi dll
RSS:
Publications
Comments

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

You can use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>