onstat -g iov command: Print AIO VP statistics

Use the onstat -g iov command to display asynchronous I/O statistics for each virtual processor.


Syntax:

>>-onstat-- -g--iov--------------------------------------------><

Example output

Figure 1. onstat -g iov command output

AIO I/O vps:
class/vp/id  s  io/s  totalops  dskread dskwrite  dskcopy  wakeups  io/wup  errors tempops
fifo  7  0   i   0.0       0       0        0         0         1     0.0      0       0
msc   6  0   i   0.1    9988       0        0         0      7833     1.3      0    9988
aio   5  0   i   0.0    4894    3341     1426         0      4393     1.1      0       0
aio   9  1   i   0.0      41       0       41         0        33     1.2      0       0
pio   4  0   i   0.0     199       0      199         0       200     1.0      0     199
lio   3  0   i   0.0    6344       0     6344         0      6344     1.0      0    6344

Output description

class

The class of the virtual processor.

vp

The ID number of the virtual processor within its class.

s

Current® status of the AIO virtual processor

f: Fork
i: Idle
s: Search
b: Busy
o: Open
c: Close

io/s

The average I/O speed (measured in operations per second) for the virtual processor since the time the database server started or since the onstat -z command was last run, whichever happened last.

totalops

Total number of I/O operations performed by this virtual processor since the time the database server started or since the onstat -z command was last run, whichever happened last.

dskread

Total number of read operations performed by this virtual processor since the time the database server started or since the onstat -z command was last run, whichever happened last.

dskwrite

Total number of write operations performed by this virtual processor since the time the database server started or since the onstat -z command was last run, whichever happened last.

dskcopy

Total number of copy operations performed by this virtual processor since the time the database server started or since the onstat -z command was last run, whichever happened last.

wakeups

For AIO VPs, the number of times the virtual processor has gone idle since the time the database server started or since the onstat -z command was last run, whichever happened last.

io/wup

For AIO VPs, the average number of I/O operations performed per wake-up by this virtual processor since the time the database server started or since the onstat -z command was last run, whichever happened last.

errors

Total number of KAIO out of resource errors.

tempops (decimal)

For internal use only. This is I/O operation counter that is maintained to determine when a new AIO VP should be added. It is applicable only when the AUTO_AIOVPS configuration parameter is enabled.