I/O Operations By Type

PROMON I/O Operations by Type Activity display

The following shows a sample I/O Operations by Type Activity display.

09/25/03             Activity: I/O Operations by Type
16:31               from 09/25/03 15:31 to 09/25/03 16:04
                                    Total   Per Min   Per Sec    Per Tx

Database reads                      57      0         0.03       0.04
  Index blocks                      13      0         0.00       0.01
  Data blocks                       44      0         0.02       0.03
BI reads                            13      0         0.00       0.00
AI Reads                            0       0         0.00       0.05
Total reads                         70      0         0.04       0.05

Database writes                     3       0         0.00       0.00
  Index blocks                      0       0         0.00       0.00
  Data blocks                       3       0         0.08       0.00
BI writes                           131     0         0.00       0.10
AI writes                           0       0         0.00       0.00
Total writes                        134     0         0.08       0.11

The display lists the following types of I/O operations:

Database reads — Total number of reads from the database:

Index blocks — The number of reads of index blocks

Data blocks — The number of reads of data blocks

BI reads — The number of blocks read from BI files

AI reads — The number of blocks read from AI files

Total reads — Total number of database, BI, and AI read operations

Database writes — Total number of writes to the database:

Index blocks — The number of writes of index blocks

Data blocks — The number of writes of data blocks

BI writes — The number of BI write operations

AI writes — The number of AI write operations

Total writes — Total number of database, BI, and AI write operations