Nandan
1st December 2005, 17:03
Baan 5.0b
Oracle 8.0.6
Sun Solaris

While importing the sequential dump, I find that the "log file sync" event for oracle is consitently increasing which may be causing the import to take more time. (As the IO load is increasing).

Is it possible to controll the commit rate by some parameter while using the bdbpost? so that I can group the writes to redo log in bulk instead of small writes every few moments.

Thanks in advance.

dave_23
1st December 2005, 18:47
Using the -r command on bdbpost will set the rows/transaction. ie., how many rows before commit.

you might want to look at log_checkpoint_interval / log_checkpoint_timeout in oracle as well. because that might help with the log sync actions.

Dave