Zoznam zamknutých tabuliek na Oracle
Locks tables na Oracle:
select
locked_mode,
object_name,
object_type,
type,
machine,
terminal,
os_user_name
from
v$locked_object lck, dba_objects obj, v$session ses
where
lck.object_id = obj.object_id
and lck.session_id=ses.sid
locked_mode,
object_name,
object_type,
type,
machine,
terminal,
os_user_name
from
v$locked_object lck, dba_objects obj, v$session ses
where
lck.object_id = obj.object_id
and lck.session_id=ses.sid