1,查询缓存中对象占用的SID
select * from v$db_object_cache where name='P_TTT';
select sid from v$accsess where object='P_TTT';
2,查询会话信息
select a.sid,a.serial#,a.sql_hash_value from v$session a;
确定是否在执行卡死的语句:
select * from v$sqlarea a where a.HASH_VALUE=XXX;
3,杀会话
alter system kill session 'sid,serial#'
select * from v$db_object_cache where name='P_TTT';
select sid from v$accsess where object='P_TTT';
2,查询会话信息
select a.sid,a.serial#,a.sql_hash_value from v$session a;
确定是否在执行卡死的语句:
select * from v$sqlarea a where a.HASH_VALUE=XXX;
3,杀会话
alter system kill session 'sid,serial#'