Snapshot Information Level Database Table Space |
API Structure(s) sqlm_dbase sqlm_tablespace sqlm_bp_info |
Monitor Group Buffer Pool Buffer Pool Buffer Pool |
Resettable |
Yes |
|
Event Information Level Database Table Space |
API Structure(s) sqlm_db_event sqlm_tablespace_event |
|
API Element Name Element Type |
pool_async_index_writes counter |
Description: The number of times a buffer pool index page was physically written to disk by either an asynchronous page cleaner, or a prefetcher. A prefetcher may have written dirty pages to disk to make space for the pages being prefetched.
Usage: You can use this element with "Buffer Pool Index Writes" to calculate the number of physical index write requests that were performed synchronously. That is, physical index page writes that were performed by database manager agents. Use the following formula:
buffer pool index writes - buffer pool asynchronous index writes
By comparing the ratio of asynchronous to synchronous writes, you can gain insight into how well the buffer pool page cleaners are performing. This ratio can be helpful when you are tuning the num_iocleaners configuration parameter.
For more information about asynchronous page cleaners, see the Administration Guide.
[ Top of Page | Table of Contents | Glossary | Index ]