Types of writes during flushing
To provide you with information about the specific condition that prompted buffer-flushing activity, the database server defines three types of writes and counts how often each write occurs.
The types of writes are as follows:
- Foreground write
- LRU write
- Chunk write
To see the write counts that the database server maintains, run the onstat -F command.
If you implement mirroring for the database server, data is always written to the primary chunk first. The write is then repeated on the mirror chunk. Writes to a mirror chunk are included in the counts.