Oracle批量kill session
tolywang
2011-10-06 15:32:40
Linux操作系统
原创
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);
dba_tab_modifications -- 表中改变行次占10%才分析统计信息
ORA-12516: TNS: 监听程序找不到符合协议堆栈要求的可用处理程'错误