This blog contains different things for Oracle DBA and APPS DBA. All these things should be tested first on test environments. Also to make this blog more useful, please give your comments and share your experience. Thanks
Friday 1 July 2011
To find the sid and serial# of a Concurrent Request in Oracle Financials R 11i and R12
Objective:
Some times we need to kill a hang concurrent request, and to kill it, we need to find the sid and serial# of that concurrent request.
Cookbook:
Following SQL query can be run with APPS user on APPS Database , it will need to provide the concurrent request id, and then it will give the sid and serial# of that concurrent requests, more information can also be obtained from v$session and v$sqlarea views.
Following is the SQL query
----------
SELECT ses.sid,
ses.serial#
FROM v$session ses,
v$process pro
WHERE ses.paddr = pro.addr
AND pro.spid IN (SELECT oracle_process_id
FROM fnd_concurrent_requests
WHERE request_id = &request_id);
---------
Subscribe to:
Post Comments (Atom)
Oracle Weblogic 12.2.1.3.0 60820: Select a domain which is a compatible with this environment. stopComponent.sh and start Component.sh give...
-
Oracle 12c Installer error - [INS-10102] Installer initialization failed - no oraInstaller in java.library.path - make sure oraInst.lo...
-
Introduction: We use EMC BCV feature to clone our production database, and it was all working fine, but suddenly we started getting the erro...
-
Introduction: In this article we will see, the impact of "Parallel" clause of rebuilding a partition index. We would also enable t...
No comments:
Post a Comment