Try running the first part.
select username,v$session.sid,serial#,owner,object_id,object_name,
object_type,v$lock.type
from dba_objects,v$lock,v$session where object_id = v$lock.id1
and v$lock.sid = v$session.sid and owner != 'SYS';
|
Results 1 to 4 of 4
Thread: table lockThreaded View
|
Click Here to Expand Forum to Full Width |