select sid, serial#, sql_text, executions
from v$sql join v$session
on v$sql.sql_id = v$session.sql_id
where cpu_time > 20000;
执行以下语句杀死
alter system kill session 'sid,serial#';
from v$sql join v$session
on v$sql.sql_id = v$session.sql_id
where cpu_time > 20000;
执行以下语句杀死
alter system kill session 'sid,serial#';