Kill Session - PID

 for pid in $(ps -ef | grep "/home/oracle/scripts/get_stale_stats_TRAMFI.sh"|awk '{print $2}'); do kill -9 $pid; done

SELECT a.request_id,

       d.sid,

       d.serial#,

       d.osuser,

       c.spid      AS db_spid,

       d.inst_id   AS rac_instance

FROM   apps.fnd_concurrent_requests   a

JOIN   apps.fnd_concurrent_processes  b ON a.controlling_manager = b.concurrent_process_id

JOIN   gv$process                     c ON c.pid = b.oracle_process_id

JOIN   gv$session                     d ON d.audsid = b.session_id

WHERE  a.request_id = 142555872;

SELECT concurrent_program_id,

              user_concurrent_program_name

FROM fnd_concurrent_programs_tl

WHERE user_concurrent_program_name LIKE '%TAS%BETC%';

UPDATE fnd_concurrent_requests

SET phase_code   = 'C',   -- Completed

    status_code  = 'X',   -- Terminated

    completion_text = 'Forcefully terminated by Ram'

WHERE concurrent_program_id = 346365

  AND phase_code = 'R';

COMMIT;

SELECT *

FROM fnd_concurrent_requests

WHERE concurrent_program_id = 346365 --and completion_text like '%Ram'

ORDER BY request_id DESC;