Progress
Database Administration
Guide and Reference
Activity Displays>Page Writers
Displays information about asynchronous page writer (APW) activity. Figure A–24 shows a sample Page Writers Activity display.
Figure A–24: PROMON Page Writers Activity Display
The display lists the following types of APW operations:
- Total DB writes — The total number of database write operations performed by all processes.
- APW DB writes — The number of database write operations performed by the APW. This is a subset of the total number of DB writes:
- Scan writes — The number of buffers written during the scan cycle.
- APW queue writes — The number of buffers written to clear the APW queue.
- Ckp queue writes — The number of buffers written from the checkpoint queue.
- Scan cycles — The number of scan cycles. During a scan cycle, the APW scans a portion of the buffer pool to look for modified buffers.
- Buffers scanned — The number of buffers scanned during each cycle.
- Bufs checkpointed — The number of buffers checkpointed.
- Checkpoints — The number of checkpoints that have occurred.
- Marked at checkpoint — The number of buffers that were scheduled to be written before the end of the checkpoint.
- Flushed at checkpoint — The number of blocks that were not written during the checkpoint and had to be written all at once at the end of the checkpoint.
- Number of APWs — The number of APWs running.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |