This dashboard helps to monitor concurrent DB transactions and locking.
Example:
Database Locking
Shows number of blocked DB transactions, high number can indicate incorrect parallel processing, for example missing DB commits after data changes in shared tables.
Missing or infrequent DB commits can be indicated using metric for object logs longer than one minute.
Object Locking
Shows duration of transaction blocking and age of oldest object lock.
Undo or Redo Size
All DB changes are recorded in Redo and Undo logs (Redo logs for point-in-time recovery, Undo logs for possible rollback operation). If these areas grow significantly, it also indicates missing or infrequent DB commits.
