1 查看数据库的等待事件
select event,count(*) from v$session where wait_class <> 'idle' group by evnent;
2.根据等待事件查看sql_id
select sid,username,sql_id,module,machine,program from v$session where event='' and sql_id is not null;
3.根据sql_id查看对应的sql语句
set long 1000000
select sql_fulltext from v$sqlarea where sql_id='';
4.杀掉会话
select sid,spid, osuser, s.program from v$session s,v$process p where s.paddr=p.addr and sid=&sid;