Displays information about I/O activity, organized 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