Skip to end of metadata
Go to start of metadata

x_cons <database_name> show dev_io

Displays the number of read and write operations of the I/O threads. If time measurements are activated, the command also displays the average I/O times.

I/O via I/O Threads only:
Volume              Devs.  Read(s)     Read  AvgRead Write(s)    Write AvgWrite
Name                  No.    Count    Pages Time(ms)    Count    Pages Time(ms)
knltrace                1        0        0    0.000        1        1    1.131
/sapdb/....ISKD0001     2        0        0    0.000       70       89   20.291
/sapdb/....ISKD0001     2    33510    33510    7.926     2331     2941   10.605
/sapdb/....ISKD0001     2     2052     2052    8.137     1564     2047   13.815
/sapdb/....ISKD0001     2      248      248    9.705     1064     1477   20.291
/sapdb/....ISKD0001     2       22       22   11.107      899     1255   18.991
/sapdb/....ISKD0001     2        2        2   14.880      781     1094   21.456
/sapdb/....ISKD0001     2        1        1   24.248      671      917   22.236
/sapdb/....ISKD0001     2        0        0    0.000      550      761   23.470
/sapdb/....ISKD0001     2        2        2   52.777      349      463   25.511
/sapdb/....ISKD0001     2        0        0    0.000      154      204   27.358

  • Volume name: Name of the media which the thread is currently accessing.
  • Devs. No.: Volume ID
  • Read Count : Read count
  • Read Pages : Total pages read
  • AvgRead time(ms): Average read time
  • Write Count : Write count
  • Write Pages : Total pages written
  • AvgWrite Time(ms) : Average write time
  • No labels