找指定Lock的Table Session
select l.*, o.owner object_owner, o.object_Name, s.LOGON_TIME
from sys.all_objects o, v$lock l, v$session S
where S.SID = l.SID
and l.type = 'TM'
and o.object_id = l.id1
and object_name in ('DAY_CLOSE','TICKET_M')
order by s.LOGON_TIME
from sys.all_objects o, v$lock l, v$session S
where S.SID = l.SID
and l.type = 'TM'
and o.object_id = l.id1
and object_name in ('DAY_CLOSE','TICKET_M')
order by s.LOGON_TIME
留言
張貼留言