Consultar DDL exec em sessão

[vieriParticipante]

---

WAIT’S EM LOCK by ChiappA

SELECT
a.osuser || ‘:’ || a.username UserID
, a.sid || ‘/’ || a.serial# usercode
, b.lock_type Type, b.mode_held Hold
, c.owner || ‘.’ || c.object_name Object
, a.program Program
, ROUND(d.seconds_in_wait/60,2) WaitMin
FROM
v$session a
, dba_locks b
, dba_objects c
, v$session_wait d
WHERE
a.sid = b.session_id
AND b.lock_type IN (‘DML’,’DDL’)
AND b.lock_id1 = c.object_id
AND b.session_id = d.sid;