5种常见锁表情况 TM

1 外键无索引
2 create index 没有加online
3 insert /*+ append+*/ into 
4 alter session enable paralle dml;
  select dml_status from v$session where sid=&sid;
5 lock table t1 in EXCLUSIVE mode;


select * from v$sqlcommand order by 2;