FIND THE TABLE WHICH HAS ROW LOCK (UPDATE/INSERT)

AS SALAMO ALAIKUM WA RAHMATULLAH

The follwoing Query publish Table name which has Row Lock due to not commit the transaction.

select
  object_name(resource_associated_entity_id) as 'TableName' ,*
from
  sys.dm_tran_locks
where resource_type = 'OBJECT'
  and resource_database_id = DB_ID()

MA ASALAAM
--
Passion 4 Oracle