Configuration parameters that affect page cleaning

Several configuration parameters, including the CLEANERS and RTO_SERVER_RESTART configuration parameters, affect page cleaning. If pages are not cleaned often enough, an sqlexec thread that performs a query might be unable to find the available pages that it needs.

If the sqlexec thread cannot find the available pages that it needs, the thread initiates a foreground write and waits for pages to be freed. Foreground writes impair performance, so you should avoid them. To reduce the frequency of foreground writes, increase the number of page cleaners or decrease the threshold for triggering a page cleaning.

Use onstat -F to monitor the frequency of foreground writes.

The following configuration parameters affect page cleaning:
  • BUFFERPOOL, which contains lrus, lru_max_dirty, and lru_min_dirty values

    Information that was specified with the BUFFERS, LRUS, LRU_MAX_DIRTY, and LRU_MIN_DIRTY configuration parameters before Version 10.0 is now specified using the BUFFERPOOL configuration parameter.


Copyright© 2018 HCL Technologies Limited