You are herelock

lock


find Session who Locking Object

simple to Check someone who locking some objects on database

Session 1:
SQL> connect scott

SQL> select * from EMP where empno=7900 for update ;

Session 2:

SQL> connect / as sysdba

Find sid and other information on lock view with object_name.

select OBJECT_ID, OWNER,OBJECT_NAME ,l.sid , l.block from dba_objects o, V$LOCK l where l.ID1=o.OBJECT_ID and object_name = '&object_name' ;

SQL> select OBJECT_ID, OWNER,OBJECT_NAME ,l.sid , l.block from dba_objects o, V$LOCK l where l.ID1=o.OBJECT_ID and object_name = 'EMP' ;



Syndicate

Syndicate content

Follow DatabasesLA on Twitter

Who's online

There are currently 0 users and 0 guests online.

Estadisticas

Locations of visitors to this page

hidden hit counter