[Tech] oracle v$lock

1. lock table

SQL> select * from v$lock;
ADDR             KADDR                   SID TYPE          ID1        ID2      LMODE    REQUEST      CTIME      BLOCK
---------------- ---------------- ---------- ------ ---------- ---------- ---------- ---------- ---------- ----------
00000000BED46A70 00000000BED46AC8          4 XR              4          0          1          0       4651          0
00000000BED46B50 00000000BED46BA8          4 RD              1          0          1          0       4651          0
00000000BED46DF0 00000000BED46E48          4 CF              0          0          2          0       4651          0
00000000BED46FB0 00000000BED47008          4 RS             25          1          2          0       4647          0
00000000BED47A48 00000000BED47AA0          5 AE            100          0          4          0       4641          0
00000000BED46C30 00000000BED46C88         14 AE            100          0          4          0        157          0
00000000BED47968 00000000BED479C0         85 KT          12876          0          4          0       4644          0
00000000BED47330 00000000BED47388         86 MR              3          0          4          0       4646          0
00000000BED47250 00000000BED472A8         86 MR              4          0          4          0       4646          0
00000000BED476B0 00000000BED47708         86 MR              5          0          4          0       4646          0
00000000BED47170 00000000BED471C8         86 MR              1          0          4          0       4646          0
00000000BED46D10 00000000BED46D68         86 MR              2          0          4          0       4646          0
00000000BED47790 00000000BED477E8         86 MR            201          0          4          0       4646          0
00000000BED47888 00000000BED478E0         86 PW              1          0          3          0       4645          0
00000000BED46ED0 00000000BED46F28         87 TS              3          1          3          0       4645          0
00000000BED47090 00000000BED470E8        171 RT              1          0          6          0       4647          0

16 rows selected.

 

2. lock object 확인

SQL> select * from v$locked_object;

no rows selected