-- -----------------------------------------------------------------------------------
-- File Name : http://www.oracle-base.com/dba/monitoring/locked_objects_internal.sql
-- Author : Tim Hall
-- Description : Lists all locks on the specific object.
-- Requirements : Access to the DBA views.
-- Call Syntax : @locked_objects_internal (object-name)
-- Last Modified: 15/07/2000
-- -----------------------------------------------------------------------------------
SET LINESIZE 1000 VERIFY OFF
COLUMN lock_type FORMAT A20
COLUMN mode_held FORMAT A10
COLUMN mode_requested FORMAT A10
COLUMN lock_id1 FORMAT A50
COLUMN lock_id2 FORMAT A30
SELECT session_id,
lock_type,
mode_held,
mode_requested,
lock_id1,
lock_id2
FROM dba_lock_internal
WHERE UPPER(lock_id1) LIKE '%&1%';
SET VERIFY ON
