For fast export
Set the buffer parameter to high value.
use direct=y
Set record length 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 index file, 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=N and analyze=N in import command
Set the buffer parameter value to high
Use commit=y
Point the import dump file on different disk file other than database file disk.
Thursday, January 1, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment