DBA_LOCK or DBA_LOCKS

Formatted view on V$LOCK that created via $ORACLE_HOME/rdbms/admin/catblock.sql

  • SESSION_ID == SID in V$LOCK
  • LOCK_TYPE, LOCK_ID1, LOCK_ID2 formatted value of TYPE, ID1, ID2 from V$LOCK
  • MODE_HELD and MODE_REQUESTED formatted value of LMODE and REQUEST from V$LOCK
  • LAST_CONVERT == CTIME of V$LOCK
  • BLOCKING_OTHERS formatted value of BLOCK from V$LOCK

Reference:

https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/DBA_LOCK.html#GUID-B19FF191-AC89-498D-B2C1-2A18F63DC03D

/0 Comments/by

Which lock modes are required for which table action? How compatibility of locks works?

The following table describes what lock modes on DML enqueues are gotten for table operations in a standard Oracle installation.

The compatibility of lock modes usually are represented by the following matrix:

/0 Comments/by