How to find lock on table object in Oracle
set linesize 190
col username for a30
select sid,serial#,username,machine from v$session where sid in (select sid from v$lock where type = 'TO' and id1 = (select object_id from dba_objects where object_name = '&temp_table_name'));
col username for a30
select sid,serial#,username,machine from v$session where sid in (select sid from v$lock where type = 'TO' and id1 = (select object_id from dba_objects where object_name = '&temp_table_name'));
Comments
Post a Comment