How to find out list of session which are blocking a temporary table
select S.username, S.osuser, S.machine, L.*, O.object_name
from SYS.V_$LOCK L, SYS.V_$SESSION S, SYS.ALL_OBJECTS O
where L.TYPE = 'TO'
and L.SID = S.SID
and L.ID1 = O.object_id
and O.object_name = 'MICACTIVISBF'
Комментариев нет:
Отправить комментарий