Query to find the session locking an object in Oracle Database

Query to find the session locking an object in Oracle Database

Query:

select

   c.owner,

   c.object_name,

   c.object_type,

   b.sid,

   b.serial#,

   b.status,

   b.osuser,

   b.machine

from

    v$locked_object a ,

   v$session b,

   dba_objects c

where

   b.sid = a.session_id

   and 

   a.object_id = c.object_id

   and c.object_name='OE_ORDER_HEADERS_ALL'

If you like please follow and comment