SELECT 'alter system kill session '''||SID || ',' || SERIAL#||''';'
FROM V$SESSION
WHERE SID in
(SELECT SESSION_ID
FROM V$LOCKED_OBJECT, USER_OBJECTS
WHERE V$LOCKED_OBJECT.OBJECT_ID = USER_OBJECTS.OBJECT_ID);
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-708686/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/35489/viewspace-708686/