SELECT b.owner, b.object_name, a.session_id, a.locked_mode FROM v$locked_object a, dba_objects b WHERE b.object_id = a.object_id;
使用toad，查询表有没有被人锁定的sql
原文：http://www.cnblogs.com/ab93/p/7723557.html
