If you are terminated the concurrent program if you want to kill the program in data base we will run the below queries
| select oracle_process_id,phase_code,status_code from fnd_concurrent_requests where request_id in (43790905); |
| ORACLE_PROCESS_ID P S |
| ------------------------------ - - |
| 16566 C X |
| 3278 C X |
| select addr from v$process where spid in (15385)--,3278); |
| ADDR |
| ---------------- |
| 628493808 |
| 000000062449BBE0 |
| select sid,serial# from v$session where paddr in ('00000006204C1410','000000062449BBE0'); |
| SID SERIAL# |
| ---------- ---------- |
| 332 12123 |
| 803 809 |
alter system kill session '332,12143';
|
