The number of times that an asynchronous page cleaner or a prefetcher wrote a data or index page from the buffer pool to a tablespace. (A prefetcher can write dirty pages to disk to make space for the pages being prefetched.)
Pages cleaners and prefetchers perform asynchronous writes before a query needs buffer pool space¾thus avoiding the stop to query processing that occurs when the database manager must write pages to disk.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center
