-- 查询正在执行的存储过程
select * from v$db_object_cache where type='PROCEDURE' and locks>0 and pins>0
-- 查询存储过程的sid
select * from v$access a where object like 'P_COUNT_MOBILELIST_RLOG%'
-- 查询存储过程的serial#
select * from v$session where sid in(71)
-- 停止存储过程
alter system kill session '71,20596' --'sid,serial#'
select * from v$db_object_cache where type='PROCEDURE' and locks>0 and pins>0
-- 查询存储过程的sid
select * from v$access a where object like 'P_COUNT_MOBILELIST_RLOG%'
-- 查询存储过程的serial#
select * from v$session where sid in(71)
-- 停止存储过程
alter system kill session '71,20596' --'sid,serial#'
8315
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
