Locks in Oracle

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 b.sid IN (SELECT l.session_id
                       FROM dba_lock_internal l
                      WHERE UPPER (l.lock_id1) LIKE '%ILP_REPORTS_PKG%');

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;

ALTER SYSTEM KILL SESSION 'sid,serial#';

SELECT    'ALTER SYSTEM KILL SESSION '''
       || SID
       || ','
       || SERIAL#
       || ',@1'
       || ''';'
  FROM gv$session
 WHERE status = 'ACTIVE' AND username = 'APEX_PUBLIC_USER';


SELECT * FROM v$access WHERE object IN ('P_ILAPERF_INT_SPLIT','P_ILAPERF_EXT_SPLIT')

select sid, event from v$session_wait where sid in (98,100);

/* Formatted on 6/20/2017 12:01:04 PM (QP5 v5.256.13226.35510) */
SELECT s.sid,
       l.lock_type,
       l.mode_held,
       l.mode_requested,
       l.lock_id1,
          'alter system kill session '''
       || s.sid
       || ','
       || s.serial#
       || ''' immediate;'
          kill_sid
  FROM dba_lock_internal l, v$session s
 WHERE     s.sid = l.session_id
       AND UPPER (l.lock_id1) LIKE '%ILA_PERFORMANCE_PKG%' --   AND l.lock_type = 'Body Definition Lock'