ТЕМА:

WITH t AS (
SELECT e.object_name,
       '%'||lower(e.object_name)||'%' object_name_like,
       to_date(a.start_time,'mm/dd/yy hh24:mi:ss') start_time,
       b.sid
  FROM gv$transaction  a, 
       gv$session      b,
       v$locked_object d,
       all_objects     e
 WHERE a.inst_id = b.inst_id
       AND a.ses_addr = b.saddr
       AND d.session_id = b.sid
       AND d.object_id = e.object_id
       AND b.sid LIKE '%%' )
SELECT z.*, t.object_name, t.sid
  FROM (
SELECT t.sql_text, t.sql_fulltext, last_active_time, t.module
  FROM v$sql t )z,
       t
WHERE LOWER(z.sql_fulltext) LIKE t.object_name_like
  AND z.last_active_time >= t.start_time
ORDER BY z.module, z.last_active_time DESC