-- SELECT LOCKED INFO'
SELECT SID
,SERIAL#
,SADDR
,MACHINE
,USERNAME
,PROGRAM
FROM V$SESSION
WHERE SID = ANY(SELECT SID
FROM V$LOCK
WHERE TYPE IN ('TX','TM')
);
-- UNLOCK SESSION
ALTER SYSTEM KILL SESSION 'SID, SERIAL#';
没有评论:
发表评论