--查詢數據庫鎖表的信息

select do.object_name,t2.username,t2.sid,t2.serial#,t2.logon_time,t2.MACHINE,t2.state,t2.STATUS
from v$locked_object t1,v$session t2,dba_objects do
where t2.STATUS='INACTIVE' and t1.session_id=t2.sid and do.object_id=t1.OBJECT_ID order by t2.logon_time;

--殺掉鎖表的記錄

alter system kill session '119,3721';

?

--查看占用連接數

select * from v$session where username='RIM_UAT' and status <>'KILLED'??

--并發連接數

select count(*) from v$session where status='ACTIVE'

?

Oracle死鎖、數據庫鏈接問題