v$lock视图SID：Identifier for session holding or acquiring the lock TYPE：Type of user or system lock TM - DML enqueue TX - Transaction enqueue UL - User suppliedLMODE：Lock mode in which t
你大概习惯了日常检视v$lock视图，了解实例中的锁定了阻塞情况，v$lock是一个非常有用的视图，每个dba都爱用他，我们来看看下面的例子:
SQL> drop table youyus;
Table dropped
SQL> create table youyus as select rownum t1 from dual connect by level update youyus s
