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);
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/25198367/viewspace-710221/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25198367/viewspace-710221/