Tuesday, 3 November 2015

SQL Query to get Session ID and Kill the session

SELECT a.request_id, d.sid, d.serial# ,d.osuser,d.process , c.SPID
 FROM apps.fnd_concurrent_requests a,
 apps.fnd_concurrent_processes b,
 v$process c,
 v$session d
 WHERE a.controlling_manager = b.concurrent_process_id
 AND c.pid = b.oracle_process_id
 AND b.session_id=d.audsid
 AND a.request_id = 277287411
 --AND a.phase_code = 'R'
 ;
alter system kill session '1403,15205'

No comments:

Post a Comment