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 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *