Oracle 10g数据库被锁记录的查询与解锁

zheng12tian

--1、查询出被锁的情况：SELECT OBJECT_ID,SESSION_ID,SERIAL#, ORACLE_USERNAME,OS_USER_NAME,S.PROCESS FROM V$LOCKED_OBJECT A, V$SESSION S WHERE A.SESSION_ID=S.SID;--2、解锁：alter system kill session 'sid,serial#';--解除所有被锁的记录alter system kill sessionSELECT SESSION_ID||','||SERIAL#FROM V$LOCKED_OBJECT A, V$SESSION S WHERE A.SESSION_ID=S.SID;