Wednesday, November 3, 2010

BTREE Cleaner, something to start with

onstat -C
onstat -C hot
onstat -C clean

onmode -C start X
onmode -C stop
onmode -C rangesize 100

If you are version 10.00.xC8 or higher I would suggest turning on ALICE=

scanning to value 6 or higher.

onmode -C alice 6

This will greatly increase the performance of the index cleaning.


Just to add that ALICE will only work if the indexes are detached which they
should if they were created under v10, but if you migrated in place, this
may not be the case...

No comments: