oracle资源占用解决方案

1.查找资源占用：

select   session_id,o.owner,o.object_name 

from V$LOCKED_OBJECT l,dba_objects o  where l.object_id=o.object_id;

2.利用查找的资源占用session_id,获取更详细的信息

select sid,serial#,username,oSUSEr,terminal,program,action,prev_exec_start from V$session where sid=490

3.删掉占用资源的会话

alter system kill session '490,47489'