clicksor ad

Tuesday, October 10, 2006

Faster import export

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=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.

No comments: