Query v$lock, v$session table : session « System Tables Views « Oracle PL / SQL






Query v$lock, v$session table

 
SQL>
SQL> set echo on;
SQL>
SQL> create table t1 ( x int );

Table created.

SQL> create table t2 ( x int );

Table created.

SQL>
SQL> insert into t1 values ( 1 );

1 row created.

SQL> insert into t2 values ( 1 );

1 row created.

SQL>
SQL> select username, v$lock.sid, id1, id2, lmode, request, block, v$lock.type
  2  from v$lock, v$session
  3  where v$lock.sid = v$session.sid and v$session.username = USER
  4  /
USERNAME                              SID        ID1        ID2      LMODE    REQUEST      BLOCK TY
------------------------------ ---------- ---------- ---------- ---------- ---------- ---------- --
JAVA2S                                 23      16651          1          3          0          0 TO
JAVA2S                                 23       8655          1          3          0          0 TO
JAVA2S                                 23      16944          1          3          0          0 TO
JAVA2S                                 24          0         22          6          0          0 JQ
JAVA2S                                 38          0         21          6          0          0 JQ
JAVA2S                                 23      16999          0          3          0          0 TM
JAVA2S                                 23      17000          0          3          0          0 TM
JAVA2S                                 23     655364        647          6          0          0 TX

8 rows selected.



 








Related examples in the same category

1.Query v$session table
2.Create view on v$session