5. 查询sql_id
selectsql_idfromv$session
wherepaddrin(
selectaddrfromv$process
wherespidin('16796','11972','9812','11652','5484')
)
6.根据5中的sql_id查询具体执行占用CPU过高的sql语句
select*fromv$sqlareawheresql_idin(sql_id1,sql_id2,sql_id3...);
SELECTsid,serial#,sql_idfromv$sessionwheresql_idin(sql_id1,sql_id2,sql_id3...)
altersystemkillsession'sid,serial#';
或批量杀进程
SELECT'alter system kill session '''||sid||','||serial#||''';'fromv$sessionwheresql_idin(sql_id);
