How to cancel a concurrent request from db level?
- The following query returns sid” and “serial#” once you have provided “request_id” of a Concurrent Program which is currently running.
- Take the values “sid” and “serial#” and kill the sessions at the database level.
Step1:Connect to SQLPLUS as the APPS user:
SQL> 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);
Enter value for request_id:
Step2:Connect to SQLPLUS as the SYSTEM user:
SQL> ALTER SYSTEM KILL SESSION '&sid,&serial#'IMMEDIATE;
Enter value for sid:
Enter value for serial:
0 comments:
Post a Comment