(转)How To Kill runaway processes After Terminating Concurrent Request

时间:2022-09-22 15:16:17

终止EBS并发请求后,解锁相关的进程。 还有种方法可以在PLSQL->tools->session 中找到并且kill

Every concurrent Request uses some resources for running. If we find that the concurrent request is taking long time and decided to terminate the concurrent request , the resources may not be released soon. These processes are called runaway processes. So we need to manually kill the processes at database and os level to have the resources released to the system. Terminate the concurrent request from the front end. Then

SQL>select request_id,oracle_process_id,os_process_id from fnd_concurrent_requests
where request_id=’&Req_Id’;
SQL>select p.spid , s.sid , s.serial# from v$session s , v$process p
where s.paddr = p.addr and s.process = &os_process_id ;
SQL> alter system kill session ‘session-id,session-serial’ $ kill -9 <server pid>
SELECT qt.user_concurrent_queue_name,
fcr.Request_Id Request_id,
fu.User_name,
p.spid,
s.sid || ',
' || s.serial# SIDSERIAL,
SUBSTR(Fcpv.Concurrent_Program_Name || ' – ' ||
Fcpv.User_Concurrent_Program_Name,
1,
46) Program,
TO_CHAR(fcr.actual_start_date, 'mm/dd hh24:mi') actual_start_date,
phase_code,
status_code,
TO_CHAR(TRUNC(SYSDATE) + (SYSDATE - fcr.actual_start_date),
'hh24:mi:ss') duration
FROM apps.Fnd_Concurrent_Queues Fcq,
apps.fnd_concurrent_queues_tl qt,
apps.Fnd_Concurrent_Requests Fcr,
apps.Fnd_Concurrent_Programs Fcp,
apps.Fnd_User Fu,
apps.Fnd_Concurrent_Processes Fpro,
v$session s,
v$process p,
apps.Fnd_Concurrent_Programs_Vl Fcpv
WHERE phase_code = 'C'
AND status_Code = 'X'
AND s.paddr = p.addr
AND fcr.requested_by = user_id
AND fcq.application_id = qt.application_id
AND fcq.concurrent_queue_id = qt.concurrent_queue_id
AND userenv('lang') = qt.language
AND fcr.os_process_id = s.process
AND fcr.Controlling_Manager = Concurrent_Process_Id
AND (fcq.concurrent_queue_id = fpro.concurrent_queue_id AND
fcq.application_id = fpro.queue_application_id)
AND (fcr.concurrent_program_id = fcp.concurrent_program_id AND
fcr.program_application_id = fcp.application_id)
AND (fcr.concurrent_program_id = fcpv.concurrent_program_id AND
fcr.program_application_id = fcpv.application_id)

(转)How To Kill runaway processes After Terminating Concurrent Request的更多相关文章

  1. How to Kill All Processes That Have Open Connection in a SQL Server Database&lbrack;关闭数据库链接 最佳方法&rsqb; -摘自网络

    SQL Server database administrators may frequently need in especially development and test environmen ...

  2. fuser - identify processes using files or sockets

    FUSER(1) User Commands FUSER(1) NAME fuser - identify processes using files or sockets SYNOPSIS fuse ...

  3. Program 3 – CS 344

    Program 3 – CS 344OverviewIn this assignment you will write your own shell in C, similar to bash. No ...

  4. Worker Thread

    http://www.codeproject.com/Articles/552/Using-Worker-Threads Introduction Worker threads are an eleg ...

  5. 《Oracle Applications DBA 基础》- 9 - Concurrent Processing&lbrack;Z&rsqb;

    <Oracle Applications DBA 基础>- 9 - Concurrent Processing================================== 参考资料 ...

  6. 《Oracle Applications DBA 基础》- 9 - Concurrent Processing

    来自:http://www.itpub.net/thread-1411293-1-4.html <Oracle Applications DBA 基础>- 9 - Concurrent P ...

  7. Oracle Applications DBA 基础(二)

    6.OAM及系统管理 2014年9月13日 20:40 参考资料: 1.Oracle Applications System Administrator's Guide - Configuration ...

  8. 基于CentOS与VmwareStation10搭建Oracle11G RAC 64集群环境

    1.资源准备 最近,在VmwareStation 10虚拟机上,基于CentOS5.4安装Oracle 11g RAC,并把过程记录下来.刚开始时,是基于CentOS 6.4安装Oracle 11g ...

  9. 使用cgroups来控制内存使用

    磨砺技术珠矶,践行数据之道,追求卓越价值 回到上一级页面:PostgreSQL内部结构与源代码研究索引页    回到*页面:PostgreSQL索引页 [作者 高健@博客园  luckyjackga ...

随机推荐

  1. 关于&lt&semi;textArea&gt&semi;控件下显示不出其它控件

    今天在写页面控件时发现我添加一个<textarea>后,在其下方的控件都显示不出来了,后来发现我忘写结束标记</textarea>了 以后该写结束标记还要写啊!

  2. ListView或GridView的Adapter使用Glide加载图片异常

    报错信息为:You must not call setTag() on a view Glide is targeting 原因就是View使用setTag后导致Glide之前请求的标记被清除,强制转 ...

  3. oracle nvl和nvl2的区别

    一直用oracle nvl函数,最近发现还有一个nvl2函数: nvl(a,b) 如果a不为null 则返回a,如果a为null则返回b; nvl2(a,b,c) ,如果a不为null 则返回b,如果 ...

  4. ASP流程控制语句

    ASP流程控制语句 1.if...then语句 单行: if 条件 then 语句 多行: if 条件 then elseif 条件 then 语句 elseif 条件 then 语句 else en ...

  5. Android调试系列—使用android studio调试smali代码

    1.工具介绍 使用工具 android killer:用于反编译apk包,得到smali代码 android studio:调试smali代码工具,或者使用idea,android studio就是在 ...

  6. bzoj 2004&colon; &lbrack;Hnoi2010&rsqb;Bus 公交线路

    Description 小Z所在的城市有N个公交车站,排列在一条长(N-1)km的直线上,从左到右依次编号为1到N,相邻公交车站间的距 离均为1km. 作为公交车线路的规划者,小Z调查了市民的需求,决 ...

  7. 富文本编辑器UEditor自定义工具栏(三、自定义工具栏功能按钮图标及工具栏样式简单修改)

    导读 富文本编辑器UEditor提供丰富了定制配置项,如果想设置个性化的工具栏按钮图标有无办法呢?答案是肯定的!前两篇博文简要介绍了通过将原工具栏隐藏,在自定义的外部按钮上,调用UEditor各命令实 ...

  8. Hive 查询元数据库获取某个分区的count数

    =========查询分区的大小========= select d.NAME,t.TBL_NAME,p.PART_NAME,prm.PARAM_KEY,prm.PARAM_VALUE from TB ...

  9. mysql生成数据字典

    git clone https://github.com/twindb/undrop-for-innodb.git make [root@redis01 undrop-for-innodb]# mak ...

  10. 树莓派 无屏幕 安装Ubuntu系统 无头安装 无显示器 用网线

    能看到此篇博客的人说明都尝试失败了,会发现内存卡刷入Ubuntu后,无法通过ssh操作树莓派.是因为官方的ubuntu系统在初次运行时需要设定一些东西,类似windows第一次启动也需要设置那样,如果 ...