TM lock（对象锁）

The following show how these locks wouldappear in the v$lock table:

SQL> create table t1 (x int);

Table created.

SQL> create table t2 ( x int);

Table created.

SQL> insert into t1 values(1);

1 row created.

SQL> insert into t2 values(1);

1 row created.

SQL> select (select username
  2     from v$session
  3     where sid = v$lock.sid) username,
  4     sid,
  5     id1,
  6     id2,
  7     lmode,
  8     request,block,v$lock.type
  9  from v$lock
 10  where sid = (select sid
 11             from v$mystat
 12             where rownum=1)
 13  /

USERNAME                              SID        ID1        ID2      LMODE
------------------------------ ---------- ---------- ---------- ----------
   REQUEST      BLOCK TY
---------- ---------- --
OPS                                   140      59573          0          3
         0          0 TM

OPS                                   140      59574          0          3
         0          0 TM

OPS                                   140     131091       2599          6
         0          0 TX


SQL> col username for a10
SQL> /

USERNAME          SID        ID1        ID2      LMODE    REQUEST      BLOCK TY
---------- ---------- ---------- ---------- ---------- ---------- ---------- --
OPS               140      59573          0          3          0          0 TM
OPS               140      59574          0          3          0          0 TM
OPS               140     131091       2599          6          0          0 TX


SQL> select object_name,object_id
  2  from user_objects
  3  where object_name in ('T1','T2')
  4  /

OBJEC  OBJECT_ID
----- ----------
T1         59573
T2         59574