The onstat -F command provides information on what types of buffer pool flushing have occurred as well as the status of each of the system page cleaner threads.
Heading | Description | Format | See Also |
---|---|---|---|
Fg Writes | The number of times a foreground write has occurred. This is caused from the sqlexec thread having to request a flush of the buffer pool page itself. | Dec | |
LRU Writes | The number of times an LRU write has occurred as performed by a page cleaner thread. | Dec | onstat -R |
Chunk Writes | The number of times a chunk write has occurred as performed during a checkpoint. | Dec | onstat -m |
address | The in-memory address of the page cleaner thread. | Hex | |
flusher | A sequential number assigned to each of the page cleaner threads. | Dec | |
state | Describes the current state of the page cleaner thread's activity using the following coded values:
C Chunk write E Exiting I Idle L LRU queue write |
Str | |
data | Data associated with the state of the page cleaner. If the state is 'C', data is the chunk number, if state is 'L', data is the number of the LRU queue, otherwise data is 0. Data is displayed in decimal followed by hexadecimal format. | Dec Hex | |
#LRU | Corresponds to the onstat -g ath thread ID output | Integer Hex | |
Chunk | Number of chunks cleaned | Integer | |
Wakeups | Number of times the flusher thread was awoken | Integer | |
Idle Time | Time in seconds the flusher thread has been idle | Dec |
To discuss how Oninit ® can assist please call on +1-913-674-0360 or alternatively just send an email specifying your requirements.