--检查下是否有阻塞 select b.sid,b.machine,c.object_name,a.oracle_username, a.locked_mode,b.osuser, 'alter system kill session '''||b.sid||','||b.serial#||''';' from v$locked_object a,v$session b,all_objects c where a.session_id=b.sid and a.object_id=c.object_id
--检查下是否有阻塞 select b.sid,b.machine,c.object_name,a.oracle_username, a.locked_mode,b.osuser, 'alter system kill session '''||b.sid||','||b.serial#||''';' from v$locked_object a,v$session b,all_objects c where a.session_id=b.sid and a.object_id=c.object_id查询结果无记录
看到
9i做个StatSpack
10g做个AWR报告。
你的截图看过了,未涉及实质行性的东西,无法精确判断问题所在。
若主机性能主要因ORACLE引起,再做个StatSpack报告,贴出结果。
select b.sid,b.machine,c.object_name,a.oracle_username,
a.locked_mode,b.osuser,
'alter system kill session '''||b.sid||','||b.serial#||''';'
from v$locked_object a,v$session b,all_objects c
where a.session_id=b.sid and a.object_id=c.object_id
select b.sid,b.machine,c.object_name,a.oracle_username,
a.locked_mode,b.osuser,
'alter system kill session '''||b.sid||','||b.serial#||''';'
from v$locked_object a,v$session b,all_objects c
where a.session_id=b.sid and a.object_id=c.object_id查询结果无记录