Displays information about miscellaneous activity.

PROMON Other Activity display

The following shows a sample Other Activity display.

09/14/03         Activity: Other
17:04:35         from 09/14/03 17:01 to 09/14/03 17:01 (10 sec)

                               Total      Per Min    Per Sec    Per Tx

Commit                         3          0          0.00       1.00
Undo                           0          0          0.00       0.00
Wait on semaphore              0          0          0.00       0.00
Non-blocking waits
Semaphore latch waits
Flush master block             3          18         0.30       1.00

The display shows the following operations:

  • Commit — The number of transactions committed
  • Undo — The number of transactions rolled back
  • Wait on semaphore — The number of times a process had to wait for a resource
  • Non-blocking waits — The number of non-blocking waits for remote clients
  • Semaphore latch waits — The number of semaphore latch waits
  • Flush master block — The number of times the database master block was written to disk