Hi all,
Unfortunately the documentation is not clear about these options.
It appeared from the test that if the log writer is disabled (that I believed give me the
best performance) the database starts flushing the data cache very often...probably
on each commit. This guess is originated from the look at the "vmstat" output
(however I might be wrong). As result having these 2 options together (SET LOG
WRITER OFF and USE_O_DIRECT YES) gave me the worst performance.
Is it right that the frequencity of the savepoints depends on the state of the log writer
(disabled/enabled)...and therefore O_DIRECT should not be used with the log
switched off?
Thanks in advance,
Dmitri Lyssenko,
Nuix Pty. Ltd.
With Yahoo! Mail you can get a bigger mailbox -- choose a size that fits your needs
