v$lock视图理解（V$lock view understanding）.doc

v$lock视图理解（V$lock view understanding） 1, the block field in v$lock indicates whether the lock blocks other locks 0 - there is no obstruction 1 - is blocked, then you can use the following statement to check who hinder This is the 2 - you encounter, usually occurs in RAC or OPS like environment, it shows that this is a global lock, this lock is used to do what the specific parameters of the TY column, TYPE v$lock explained in the online document. Example： (1) view v$lock information SQL, select *, from, v$lock, where, Sid, in (1,42), order, by, sid; ADDR, KADDR, SID, TY, ID1, ID2, LMODE, REQUEST, BLOCK, CTIME ---------------------------------------------------------------------------------------- 372810E0 3728110C 1 AE 1000408352 37280BE4 37280C10 42 AE 1000407862 (2) session 42 SQL select * from t_user; USER_ID USER_NAME USER_EMAIL ------------------------------------------------------------ 1 Alex alex200905@163.com SQL, update, t_user, set, user_id=2, where, user_id=1; 1 row updated. (3) view v$lock information SQL, select *, from, v$lock, where, Sid, in (1,42), order, by, sid; ADDR, KADDR, SID, TY, ID1, ID2, LMODE, REQUEST, BLOCK, CTIME ---------------------------------------------------------------------------------------- 372810E0 3728110C 1 AE 1000408622 367F2DB4 367F2DF4 42 TX 45877330956062 00757A9C 00757ACC 42 TM 7493403062 37280BE4 37280C10 42 AE 1000408132 (4) session 1 SQL select * from t_user; USER_ID USER_NAME USER_EMAIL ---------- -------------------- ------------------------------ 1亚历克斯alex200905@163.com SQL 更新t_user集user_id = 3，user_name = alex”； 锁等待 （5）、查看V $锁信息 SQL 选择*从V $锁定sid（1,42）以SID； 地址kaddr SID TY Id1 ID2 lmode请求CTime块 -------- -------- ---------- -- ---------- ---------- ---------- ---------- ---------- ---------- 3728123c1 3095 0 6 24 0 458773 00757a9c 00757acc TM 74934 0 3 0 24 1 2 372810e0 3728110c 1 AE 100 0 4 0 937 2 367f2db4 367f2df4 42 TX 458773 3095 6 0 81 1 00757a9c 00757acc TM 74934 0 3 0 81 42 2 37280be4 37280c10 42 A