Oracle 10g v$lock

v$lock_type

v$lock_type 은 10g에서 새로 추가된 view이다.

SQL> desc v$lock_type

Name Null? Type

----------------------------------------------------- -------- ------------------------------------

TYPE VARCHAR2(64)

NAME VARCHAR2(64)

ID1_TAG VARCHAR2(64)

ID2_TAG VARCHAR2(64)

IS_USER VARCHAR2(3)

DESCRIPTION VARCHAR2(4000)

TYPE은 두글자로 표현되는 LOCK의 약어이다.

SQL> select count(*) from v$lock_type;

COUNT(*)

----------

155

10g 10.2.0.1.0 에서는 155개의 LOCK TYPE이 정의되어있다.

1 select * from v$lock_type

2* where type in ('TX','TM')

SQL> /

TYPE NAME ID1_TAG ID2_TAG IS_USER DESCRIPTION

---- ----------- --------------- --------------- ------- ------------------------------

TM DML object # table/partition YES Synchronizes accesses to an ob

ject

TX Transaction usn<<16 | slot sequence YES Lock held by a transaction to

allow other transactions to wa

it for it

Lee