1  –  total_locks_field

    This field gives statistics for all types of database locks.

2  –  area_locks_field

    This field gives statistics for database physical area locks.

3  –  buffer_page_locks_field

    This field gives statistics for database page locks. Page locks
    manage the database page buffer pool.

4  –  record_locks_field

    This field gives statistics for database record locks. Record
    locks maintain the logical consistency of the database. This set
    of statistics includes all record locks in the adjustable lock
    granularity tree.

5  –  SEQBLK lock field

    This field gives statistics for the database sequence block
    (SEQBLK) locks. The SEQBLK locks maintain global sequence numbers
    or transaction and commit sequence numbers and control COMMIT and
    ROLLBACK operations.

6  –  FILID locks field

    This field gives statistics for the database file identification
    (FILID) locks. The FILID locks maintain consistent end-of-file
    information for the .rdb, .rda, and .snp database files.

7  –  TSNBLK locks field

    This field gives statistics for the database transaction block
    (TSNBLK) locks. The TSNBLK locks control the COMMIT and ROLLBACK
    operations on each VMScluster node. TSNBLK locks are also
    used to control SQL SET TRANSACTION statements for read-only
    transactions.

8  –  RTUPB lock field

    This field gives statistics for the database run-time user
    process block (RTUPB) lock. The RTUPB locks maintain a consistent
    list of the users who are attached to the database.

9  –  ACTIVE lock field

    This field gives statistics for the database ACTIVE user bit map
    lock. The ACTIVE lock maintains a consistent list (in bit map
    form) of the users who are attached to the database.

10  –  MEMBIT lock field

    This field gives statistics for the database MEMBIT node bit map
    lock. The MEMBIT locks maintain a consistent list (in bit map
    form) of the VMScluster nodes on which the database is currently
    accessed.

11  –  AIJ locks field

    This field gives statistics for the after-image journal (AIJ)
    locks. AIJ locks control reading from and writing to the
    .aij file. One global AIJ lock maintains current end-of-file
    information. In addition, there is one local AIJ lock on each
    VMScluster node that manages the global AIJ buffer on that node.

12  –  snapshot_locks_field

    This field gives statistics for the database snapshot locks.
    Snapshot locks manage the allocation of snapshot pages to users
    who are updating the database. Snapshot locks are only used if
    snapshots are enabled for a storage area.

13  –  freeze_lock_field

    This field gives statistics for the database freeze lock. The
    freeze lock suspends database activity while a database recovery
    process is running.

14  –  quiet_point_lock_field

    This field gives statistics for the database quiet-point lock.
    The quiet-point lock suspends starting new transactions while
    the AIJ despooler is trying to finish despooling the contents
    of the primary .aij file when you use the RMU Backup After_
    Journal command. The quiet-point lock also suspends starting new
    transactions during the startup of an online RMU Backup command.

15  –  logical_area_locks_field

    Logical area locks are obtained when Oracle Rdb readies tables.
    Lock carryover can help reduce the number of logical area locks.

16  –  nowait_transaction_field

 This field gives statistics for the database nowait transaction
 lock.

17  –  CLIENT locks field

    This field monitors the database client information (CLIENT)
    lock. The CLIENT locks are used to provide serialized access to
    the database metadata stored in the system tables. The CLIENT
    locks are also used to serialize operations such as creating
    tables and indices.

    Note: This field is only displayed on terminal displays
    containing more than 24 lines.