Rudy的专栏

oracle查看锁信息可以通过v$lock视图 SCOTT@orcl>select sid,type,id1,id2,lmode,block,request from v$lock where sid in(133,199) order by sid;        SID TY        ID1        ID2      LMODE      BLOCK    REQU

创建测试表 SQL> CREATE TABLE t AS 2 3 SELECT rownum AS id, 4 round(dbms_random.normal*1000) AS val1, 5 100+round(ln(rownum/3.25+2)) AS val2, 6 100+round(ln(rownum/3.25+2)) AS val3, 7 dbms_random.stri