Oracle和达梦：获取表是否被锁定

1、获取表是否被锁定

select "V$SESSIONS".SESS_ID,"V$SESSIONS".SQL_TEXT,"V$SESSIONS".STATE,"V$SESSIONS".CURR_SCH,"V$SESSIONS".USER_NAME,"V$SESSIONS".TRX_ID,"V$SESSIONS".CREATE_TIME

from v$sessions  where trx_id in(

 select trx_id from v$lock where table_id in (

  select tab.id from sysobjects sch,sysobjects tab

  where tab.schid=sch.id and sch.name||'.'||tab.name='你的表名'))

and SQL_TEXT like '%insert%' or SQL_TEXT like '%update%' or SQL_TEXT like '%delete%';

2、解除锁定

sp_close_session(查询到的SESS_ID)；

3、总结

参考：http://t.csdnimg.cn/IosAw