查询锁表SQL
SELECT SESS.SID,
SESS.SERIAL
LO.ORACLE_USERNAME,
LO.OS_USER_NAME,
AO.OBJECT_NAME,
LO.LOCKED_MODE
FROM V$LOCKED_OBJECT LO, DBA_OBJECTS AO, V$SESSION SESS, V$PROCESS P
WHERE AO.OBJECT_ID = LO.OBJECT_ID
AND LO.SESSION_ID = SESS.SID;
杀掉session
alter system kill session '575,24071';
DECLARE
CURSOR MYCUR IS
SELECT B.SID, B.SERIAL
FROM V$LOCKED_OBJECT A, V$SESSION B
WHERE A.SESSION_ID = B.SID
GROUP BY B.SID, B.SERIAL
BEGIN
FOR CUR IN MYCUR
LOOP
EXECUTE IMMEDIATE ('alter system kill session ''' || CUR.SID || ',' ||
CUR.SERIAL# || ''' ');
END LOOP;
查询存储过程
select * from user_source t;