How to cancel a concurrent request from db level?

on Tuesday, 5 June 2012

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