Oracle ERP Interface堵住--Request Running too long time,查找Request执行的Sql
来源:互联网 发布:jquery.easing.js 编辑:程序博客网 时间:2024/04/29 23:56
Request Running too long time
堵住了INV Manager
导致INV Interface Pending 很多笔资料
Review 发现Request 实际执行SQL 为空,Request Idle(SQL 如下,之前weiheng提供,很好用)
通过Cancel Request 后,状况恢复正常
具体Sql:
--------------------------------
-- 由request id 查 os procesee id
select os_process_id from apps.fnd_concurrent_requests where request_id='&Request_id';
--由os process id 查 sid
select s.INST_ID,s.PROCESS,s.SID,p.SPID,s.LAST_CALL_ET,s.MACHINE,s.SERIAL#,s.OSUSER,s.USERNAME,s.PADDR
from gv$session s,gv$process p
where s.PROCESS='&Process' and s.PADDR=p.ADDR;
--由SID查目前wait event
select s.SID,so.CONSISTENT_GETS,s.LAST_CALL_ET,sw.EVENT,sw.*
from v$session s,v$sess_io so,v$session_wait sw
where s.SID = '&SID'
and s.SID=so.SID and s.SID=sw.SID;
--由SID查目前執行sql
select s.SID "db session",sq.sql_text "SQL_COMMAND"
from gv$process p,gv$session s,v$sqltext sq
where
p.ADDR = s.PADDR(+) and s.sql_address=sq.address(+) and s.sql_hash_value=sq.hash_value(+) and
s.SID = '&SID'
order by sq.PIECE;
---------------------------
- Oracle ERP Interface堵住--Request Running too long time,查找Request执行的Sql
- [Script]Long Running Concurrent Request in Oracle EBS
- 修改MaxFieldLength与MaxRequestBytes彻底解决Request Too Long的问题
- Oracle EBS R12 - SQL to find session ID of the running request from request ID
- [IIS]修改MaxFieldLength与MaxRequestBytes彻底解决Request Too Long的问题
- HTTP Error 414. The request URL is too long解决方法
- HTTP 414 “Request URI too long” 表单提交内容太多
- 413 Request Entity Too Large 的解决方法
- 413 Request Entity Too Large 的解决方法
- 查找Request
- The difference between the request time and the current time is too large.
- The request filtering module is configured to deny a request where the query string is too long.
- snmp request time out?
- oracle 查找执行过的sql
- 413 Request Entity Too Large
- 413 Request Entity Too Large
- 413 Request Entity Too Large
- 413 Request Entity Too Large
- 高等几何——周兴和答案1(自己写的,非标准答案,望指正)
- 使用Java调用ElasticSearch提供的相关API进行数据搜索完整实例演示
- Linux c 开发 - Autotools使用详细解读
- 删除文件夹里的所有文件
- 210 - Concurrency Simulator
- Oracle ERP Interface堵住--Request Running too long time,查找Request执行的Sql
- java(jdk)环境变量配置(XP、win7、win8)
- Java开发中的23种设计模式详解(转)
- eclipse Luna CDT
- 矩阵分解-推荐应用
- Android json数据解析
- ScrollView+GridView组合,GridView无法全部显示解决办法
- JSP中动态include与静态include的区别介绍
- 矩阵分解大全matlab