-----查询一个被锁定的session
SELECT A.OBJECT_NAME, A.STATUS, V.SESSION_ID FROM ALL_OBJECTS A, V$LOCKED_OBJECT V WHERE A.OBJECT_ID = V.OBJECT_ID AND A.OBJECT_NAME LIKE 'FM_SYS_FUNCTION%';SELECT A.OBJECT_NAME, A.STATUS
-----查询一个被锁定的session
SELECT A.OBJECT_NAME, A.STATUS, V.SESSION_ID FROM ALL_OBJECTS A, V$LOCKED_OBJECT V WHERE A.OBJECT_ID = V.OBJECT_ID AND A.OBJECT_NAME LIKE 'FM_SYS_FUNCTION%';SELECT A.OBJECT_NAME, A.STATUS