How to Improve Performance 5-17

Page-Cleaner Parameters

Page-Cleaner Parameters
In the discussion of page-cleaning tuning, it is especially true that your
hardware configuration and your application influence the values that are
best for your environment.
Familiarize yourself with the OnLine approach to page cleaning before you
begin this section. Refer to page 2-57 andpage 2-58 for background infor-
mation about theLRU queues and their role in the page-cleaning process.
You can tune four page-cleaning parameters to affectperformance:

Efficient Page Cleaning

Traditionally,theeffectiveness of page-cleaner activity has been measured by
the different types of writes performed. Idle writes occur when the page
cleanerswake by themselves to flush the LRU queues. Foreground writes occur
ifthe database server process must initiate page flushing. (Refer to page 2-75
for a description of the different types of writes that occur during OnLine
operation.) You can examine the types of writes that occur in your
environment by executingtbstat -F.
CLEANERS The number of page cleaners
LRUS The number ofLRU queue pairs
LRU_MAX_DIRTY Thethreshold percentage of modified buffers in the queue,
which when reached initiates page-cleaning activity (as
idle writes)
LRU_MIN_DIRTY Thethreshold percentage of modified buffers in the queue,
which when reached indicates the point at which page-
cleaning activity can be suspended