Snapshot Information Level Database |
API Structure(s) sqlm_dbase |
Monitor Group Buffer Pool |
Resettable |
Yes |
|
Event Information Level Database |
API Structure(s) sqlm_db_event |
|
API Element Name Element Type |
pool_drty_pg_steal_clns counter |
Description: The number of times a page cleaner was invoked because a synchronous write was needed during the victim buffer replacement for the database.
Usage: Using the following formula, you may calculate what percentage of all cleaner invocations are represented by this element:
buffer pool victim page cleaners triggered
/ ( buffer pool victim page cleaners triggered
+ buffer pool threshold cleaners triggered
+ buffer pool log space cleaners triggered)
If this ratio is low, it may indicate that you have defined too many page cleaners. If it is high, it may indicate that you have too few page cleaners defined (see the Administration Guide).
[ Top of Page | Table of Contents | Glossary | Index ]